About
Pricing
Community
Teams
Start Free Trial
Log in
marrowyung
asked on
8/24/2015
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..
Microsoft SQL Server
Windows Server 2008
8
1
Last Comment
Systech Admin
8/22/2022 - Mon
Systech Admin
8/24/2015
you will need to add the users to SQLAgentOperatorRole. For more information please refer below link
https://technet.microsoft.com/en-us/library/ms188283(v=sql.110).aspx
marrowyung
8/24/2015
ASKER
so this one can allow me to script out any SP and jobs I want so that I can keep a backup ?
marrowyung
8/24/2015
ASKER
so if the SP in master DB can I also script that out by this permission ?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Systech Admin
8/24/2015
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
marrowyung
8/24/2015
ASKER
"and also you can add the user to sysadmin role"
so without this I can't do what ?
Systech Admin
8/24/2015
You can do that without that also
marrowyung
8/24/2015
ASKER
so just this role SQLAgentOperatorRole is enough ? so why I need the sysadmin role, or I have someone to generate it for me ?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Systech Admin
8/24/2015
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