What are the Security Settings for a login to only allow Backup to be performed

Question

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.

Thanks.

Answer 1

Hello,

The login must be at least member of the database role db_backupoperator to backup the database.

---

Olaf Helper

Blog Xing

Answer 2

Olaf,

Thanks for the reply.

I do not have that role listed.  I only have/see the following roles:
bulkadmin
dbcreator
diskadmin
processadmin
public
securityadmin
setupadmin
sysadmin

And I am not aware of how to add new roles.

Answer 3

Olaf,

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!