Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,964 of 19,505    |
|    Erland Sommarskog to Chad Jones    |
|    Re: 'Backup Database' permission    |
|    05 Dec 13 23:19:35    |
      From: esquel@sommarskog.se              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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca