Groups > comp.databases.ms-sqlserver > #1627

Re: 'Backup Database' permission

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: 'Backup Database' permission
Date	2013-12-05 23:19 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA28DED4A27680Yazorman@127.0.0.1> (permalink)
References	<l7qlqa$kfg$1@news.albasani.net>

Show all headers | View raw

Chad Jones (noreply@noreply.com) writes:
> Can any one tell me if it's possible to grant the 'Backup 
> Database' permission to a user, but only for a disk location, 
> not a tape device?  Thanks
> 

I don't think so. SQL Server writes to the backup device using its own
identity; it does not impersonate the actual user, so you cannot control
it with direct permissions on the device either.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

'Backup Database' permission Chad Jones <noreply@noreply.com> - 2013-12-05 11:57 -0800
  Re: 'Backup Database' permission Erland Sommarskog <esquel@sommarskog.se> - 2013-12-05 23:19 +0100
    Re: 'Backup Database' permission rja.carnegie@gmail.com - 2013-12-05 16:14 -0800
      Re: 'Backup Database' permission Erland Sommarskog <esquel@sommarskog.se> - 2013-12-06 21:58 +0100
        Re: 'Backup Database' permission Chad Jones <noreply@noreply.com> - 2013-12-06 13:20 -0800
          Re: 'Backup Database' permission Erland Sommarskog <esquel@sommarskog.se> - 2013-12-06 23:41 +0100
            Re: 'Backup Database' permission Mark D Powell <Mark.Powell2@hp.com> - 2013-12-24 12:26 -0800

csiph-web