db rights

How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB? How do you set up a DBA user other than sa?
Hi,
How do you set up a DBA user other than sa?
Assign the "SYSADMIN" server fixed role to that user using the below command
sp_addsrvrolemember <Logsin Name>,sysadmin
How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB?
Assign "db_backupoperator" to user. This will allow users to backup not
restore. Restore database permission can not be granted.
sp_addrolemember 'db_backupoperator',<User Name>
If you assign the server fixed "dbcreator" role. The user will be able to
Backup, restore , create database, drop database and alter database.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:unI8kgNKEHA.1144@.TK2MSFTNGP12.phx.gbl...
> How do you set up an user which can do backup and restore DB but do not
have
> read or write right to that DB? How do you set up a DBA user other than
sa?
>