Tuesday, February 26, 2013 2:53 PM
I am looking to create a Login for SQL2008 R2 that only has the permissions to perform Backups.
I do not want this login to be able to Delete, Drop, Detach, or view or edit Table structure or data. This login is essentially a Backup only account.
What security settings do I need to set to have this work?
Any help and guidance would be appreciated.
Tuesday, February 26, 2013 3:05 PM
The login must be at least member of the database role db_backupoperator to backup the database.
Olaf HelperBlog Xing
- Marked As Answer by MrAvgProgrammer Tuesday, February 26, 2013 4:04 PM
Tuesday, February 26, 2013 3:10 PM
Thanks for the reply.
I do not have that role listed. I only have/see the following roles:
And I am not aware of how to add new roles.
Tuesday, February 26, 2013 3:47 PM
I found what I was looking for. You were correct. I was looking at the Server Roles. I needed to look at Database level roles. Thanks!