Home > IT Answers > SQL Server > Job permissions in SQL Server Agent
Dreadnought303
20 pts.
 Job permissions in SQL Server Agent
SQL Server 2000, SQL Server Agent, SQL Server Agent job permissions, SQL Server user permissions, SQLAgentReaderRole
Hi, I'm using SQL Server Agent which is running on SQL Server 2000. My question is, is there a way to give permissions to users to simply view the jobs and not change/execute them? I've read that this is possible in SQL 2005 with SQLAgentReaderRole, but what about 2000? Thanks in advance.

Software/Hardware used:
ASKED: February 26, 2009  3:50 AM
UPDATED: February 26, 2009  6:36 PM
RELATED QUESTIONS
Answer Wiki:
Thanks for the help. I was researching this online and it seems that SQL 2000 needs Service Pack 3 for TargetServersRole. Is this true?
Last Wiki Answer Submitted:  February 26, 2009  8:57 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

It is possible that SP3 is possible. SP4 for SQL 2000 has been available for years. Every SQL 2000 server should be patched to SP4 plus the latest hotfix at this point.

Denny Cherry
 64,520 pts.