July 19, 2012 at 1:15 am
Hi
I need to have a instance wide user that can only backup and restore databases.
I looked at the below link and it looks like dbcreator is the user that I need but not sure if I'm correct. Does this user have the same permissions as db_backupoperator has a a single database?
http://msdn.microsoft.com/en-us/library/ms188659.aspx
The Fastest Methods aren't always the Quickest Methods
July 19, 2012 at 1:58 am
EXEC sp_srvrolepermission 'dbcreator';
EXEC sp_dbfixedrolepermission 'db_backupoperator';
DBCreator can only restore while db_backupoperator can backup.
Easiest thing to do is add the user to the model database with db_backupoperator and then when a new DB is created, so is the login with the backup role.
Granted will need to add the user to the already exsiting DB's but that would be a simple script wrapped in a sp_msforeachdb call.
July 19, 2012 at 3:55 am
awesome thank you 😀
The Fastest Methods aren't always the Quickest Methods
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply