asked on
permission to read SQL server job content and script that out
Dear all,
What should be the permission I need to script out SQL server SP and SQL job? I need to backup sth I wrote for SQL server ? script/SP, etc..
What should be the permission I need to script out SQL server SP and SQL job? I need to backup sth I wrote for SQL server ? script/SP, etc..
Microsoft SQL ServerWindows Server 2008
Last Comment
Systech Admin
ASKER
so this one can allow me to script out any SP and jobs I want so that I can keep a backup ?
ASKER
so if the SP in master DB can I also script that out by this permission ?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
"and also you can add the user to sysadmin role"
so without this I can't do what ?
so without this I can't do what ?
You can do that without that also
ASKER
so just this role SQLAgentOperatorRole is enough ? so why I need the sysadmin role, or I have someone to generate it for me ?
no just go ahead with SQLAgentoperator role that will work, no need of sysadmin role
https://technet.microsoft.com/en-us/library/ms188283(v=sql.110).aspx