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 : 07:42:44
|
| 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.com |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-12-19 : 11:36:56
|
| The built in database Roles for Jobs don't help with modification. A User can modify Jobs owned but only SysAdmin can modify everyone's Jobs. It seems silly to me but that's how it is.=======================================Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith |
 |
|
|
Jayam.cnu
Starting Member
45 Posts |
Posted - 2011-12-20 : 03:45:41
|
| Yes, you are correct. SA can do anything on Serverl level. But my requirement is the one which I've mentioned. So pelase let me know, if I can do anything which suits my requirement.Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-20 : 04:26:26
|
| Are you sure you assigned the roles in the msdb database ?PBUH |
|
|
|
Jayam.cnu
Starting Member
45 Posts |
Posted - 2011-12-20 : 05:06:37
|
| Yes,I am sure about it. Because, after providing those roles in MSDB, I tried, but unable to Modify any job on the server. Those roles can gives Read and Create permissions, but not Modify. Please give me a better solution in this regard.Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-20 : 06:02:35
|
| Under which user are those jobs running ?Is it running under the same user to whom you are assigning the operator rights ?PBUH |
|
|
|
Jayam.cnu
Starting Member
45 Posts |
Posted - 2011-12-20 : 06:17:50
|
| The jobs are running under SA account and few other accounts. But they are not at all running under the User to whom I want to provide permissions. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-20 : 07:02:18
|
quote:
Originally posted by Jayam.cnu
The jobs are running under SA account and few other accounts. But they are not at all running under the User to whom I want to provide permissions.
No..then the login wont be allowed to edit the job.Make the job run under the account to whom you want assign the agentoperator role.PBUH |
|
|
|
|
|
|
|
|
Role To Modify SQL Jobs