April 7, 2008 at 12:44 pm
How can I grant permission to technical people in our dev and qa server where they can do their application database (specific ones only) backup and restore without sysadmin?
April 7, 2008 at 12:56 pm
Looks like you'd have to assign them to db_owner in those databases that you want them to have backup and restore rights. If you only want to give the rights to backup the database you could assign them to the db_backupoperator role.
😎
April 7, 2008 at 1:00 pm
I want to give them both backup and restore. I will look at the db_owner with backup and restore.
April 7, 2008 at 1:16 pm
This only works with the database to do the backup and restore. if I have backup from somewhere else where the user ids are different db_owner can't restore as they loose their db_owner permission while restoring backup from other enviornment.
April 7, 2008 at 1:28 pm
From what I can tell, then the only option short of sysadmin is the dbcreator fixed server role. This would allow them to create new databases, but also to restore the ones they have permissions.
😎
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply