How to grant [DatabaseBackup] SP execution privilege to a none sysadmin role user? #977
Unanswered
JParkACR
asked this question in
Questions & Answers
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I (SA) granted the Ola hallengren's
[DatabaseBackup]SP execution privilege to a none sysadmin role user.But the user failed to make a backup due to the '
xp_ss_delete' or 'xp_fileexist' system sps.I found '
@ExecuteAsUser' parameter in[CommandExecute]SP, but there is no documentation about this parameter and couldn't figure out how to use it.Is there anyone who can successfully grant the
[DatabaseBackup]privileges to a none-sysadmin role user??Beta Was this translation helpful? Give feedback.
All reactions