November 17, 2010 at 4:37 pm
A colleague of mine needs owner rights on a database plus backup and restore rights to that same database.
I've given the user "dbcreator","db_backuperator" and "db_owner" permissions but upon restoring the database he loses these permissions and I have to sp_change_users_login to make it work again which he can't do.
What am I missing here? What permissions do I need to give so the user can be a dbowner + do backups and restores of the database whenever he wants.
November 17, 2010 at 5:30 pm
November 17, 2010 at 9:43 pm
pavan_srirangam (11/17/2010)
Just give him db_securityadmin. works fine for that.
Secutityadmin members can GRANT, REVOKE, DENY permissions. It has nothing to do with RESTORE permissions. More details here
Minimum requirements:
To backup a database:- Member of db_owner and db_backupoperator roles
To restore a database:- Member of dbcreator role
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply