Monday, February 20, 2012

permission

Dear all
what account permission can run script and backup database ? not sa account
thx
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
>
|||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 Smeyer" <JensSmeyer@.discussions.microsoft.com> wrote in message
news:72DC1ABC-B9E5-492A-921D-62E479457462@.microsoft.com...[vbcol=seagreen]
> Look for
> db_backupoperator Has permission to back up the database.
> in BOL
> HTH, Jens Suessmeyer.
>
> "123" wrote:

No comments:

Post a Comment