Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2011-12-19 : 06:46:33
|
| Hi,I need to assign permissions to a User to Create/Modify the jobs on a server. I've tried giving SQLAgentOperator, SQLAgentUser and other roles for MSDB. But, the user couldn't be able to create/modify the jobs. So please let me know any option which suits our requirement. It's urgent!!!Note : I shouldn't give him SA role and he is not the owner of any job located on that server.Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.comedit: moved to proper forum |
|
|
pnash
Starting Member
26 Posts |
Posted - 2011-12-19 : 13:10:05
|
| user having SQLAgentOperator permission should able to modify the job. what error u are getting while modifying the job. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-12-19 : 14:07:24
|
| When you create the login - it must match the AD account exactly. That is, if the AD account is all uppercase and the login in SQL Server is all lowercase it won't work. |
|
|
|
|
|
|
Role To Modify SQL Jobs