Monday, February 20, 2012

permission

Dear all
what account permission can run script and backup database ? not sa account
thxLook for
db_backupoperator Has permission to back up the database.
in BOL
HTH, Jens Suessmeyer.
"123" wrote:
> Dear all
> what account permission can run script and backup database ? not sa account
> thx
>|||Hi,
To add on to Jens, you could also give the below GRANT permission
exclusevely to a User to BACKUP the database.
GRANT BACKUP DATABASE TO <User_name>
For Transaction Log
GRANT BACKUP LOG TO <USER_Name>
Thanks
Hari
SQL Server MVP
"Jens Süßmeyer" <JensSmeyer@.discussions.microsoft.com> wrote in message
news:72DC1ABC-B9E5-492A-921D-62E479457462@.microsoft.com...
> Look for
> db_backupoperator Has permission to back up the database.
> in BOL
> HTH, Jens Suessmeyer.
>
> "123" wrote:
>> Dear all
>> what account permission can run script and backup database ? not sa
>> account
>> thx
>>

No comments:

Post a Comment