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 |
|
sriksdave
Starting Member
5 Posts |
 Posted - 2007-05-04 : 22:49:56
|
| Hello GuysIam trying to make the SQL Server Agent read only for a particular group of users.First thing I did was I took off the group of users from the SQL Server administrator previlegesThen I normally added them to the server logins so that they can log into the server.Then I gave them access to the MSDB database so that they can access the SQL Agent Job Specific stored procedures.Then I granted them execute permission on all the SQL Agent Stored procedures (Thought I would first make it work then I will make it read only by taking off permission on the Job changing stored procs).Now When i login as one of the users of the group and try to view the jobs. I still cannot see any of the jobs listed. and when i try to run the stored proc "exec sp_help_job", it still does not list any of the jobs.Can anyone tell me if I am missing something.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-05 : 12:49:28
|
| Just put them in targetserverrole in msdb. |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-05-06 : 15:40:48
|
| There is no strait forward way other than TargetServerRole in msdb as mentioned where as in SQL Server 2005 new roles introduced for this type of acess...MohammedU |
|
|
|
sriksdave
Starting Member
5 Posts |
Posted - 2007-05-06 : 21:32:42
|
quote:
Originally posted by rmiao
Just put them in targetserverrole in msdb.
Thanks man, that will work You Rock! |
|
|
|
|
|
|
SqlAgent Jobs ReadOnly Access