Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1627
| Path | csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: 'Backup Database' permission |
| Date | Thu, 05 Dec 2013 23:19:35 +0100 |
| Organization | Erland Sommarskog |
| Lines | 14 |
| Message-ID | <XnsA28DED4A27680Yazorman@127.0.0.1> (permalink) |
| References | <l7qlqa$kfg$1@news.albasani.net> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | mx05.eternal-september.org; posting-host="fd3d6d0229f14a752f017d8f9903addd"; logging-data="28876"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18dKWC+sKLTQTrLTYcmFLz4" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:y65+x24+d/darxn5ThfF1cMovD8= |
| Xref | csiph.com comp.databases.ms-sqlserver:1627 |
Show key headers only | 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
'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