July 17, 2006 at 1:38 pm
Is there a way to grant a users the ability to do backups and restores without withput macking them System Administrators.
July 17, 2006 at 11:40 pm
Have you thought about adding them to the Server Role "Database Creators"? That role has the following permissions: ALTER DATABASE, CREATE DATABASE, DROP DATABASE, Extend Database, RESTORE DATABASE, RESTORE LOG and sp_renamedb
Thanks
July 18, 2006 at 6:28 am
Dear,
Do u want to give access to a user to backup a paticular database only or all databases.
BTW what so every . u can try as deadwood wrote or read about tha database role in BOL.
HTH
from
Killer
July 18, 2006 at 12:37 pm
Thanks for replying. I am currently looking at role option. I do want to do this only to specific databases on the server. Thanks for all your help.
July 18, 2006 at 8:15 pm
You can do backups with just the db_backupoperator fixed database role. This does not, however, give you the ability to do restores. The only way to restrict RESTORE permissions to individual databases is if the user doing the restore is the owner of the database.
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply