March 7, 2006 at 2:57 pm
I would like to give a user permission to do restores to a specific database. I thought that putting him in "Database Creators" role, and "dbo_owner" to the DB would work. However, I get "User does not have permission to RESTORE database 'Test_db' "
Any thoughts on this ??
March 7, 2006 at 6:26 pm
You need to add the user as a member of the server role 'dbcreator'. In QA type the following to see the permissions for this particular role:
sp_srvrolepermission 'dbcreator'
March 8, 2006 at 9:12 am
Be aware that a member of dbcreator server role can restore any database in the instance. I believe the only way to restrict the RESTORE permission to a particular database is to password protect backup sets.
Greg
Greg
March 8, 2006 at 9:27 am
Maybe I can script the process into a job, running under an account that has permission, and just let him start the job ?
March 8, 2006 at 2:15 pm
Maybe, if the job step with the RESTORE command is run as dbo.
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply