SQL Server Performance Forum – Threads Archive

SQL Server

What permissions should i grant a user who only wants to see SQL Server jobs from enterprise manager. I am using Windows Authentication. Thanks,
cali

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=270 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

If you are using sql server 2005…check BOL topic "SQL Server Agent Fixed Database Roles" http://msdn2.microsoft.com/en-us/library/ms188283.aspx If you are using sql server 2000 then check the TARGETSERVER ROLE in msdb database… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Members of SQLAgentUserRole and SQLAgentReaderRole can only start jobs that they own.
Members of SQLAgentOperatorRole can start all local jobs including those that are owned by other users.
Members of sysadmin can start all local and multiserver jobs.

Thanks everyone for the answer.

]]>