Showing posts with label allwhat. Show all posts
Showing posts with label allwhat. Show all posts

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: