SQL Server Performance Forum – Threads Archive
Permission to view/create/edit/delete SQL jobs
Dear all,I need to provide a user to view/create/edit/delete SQL jobs in SQL Server 2005.
How to proceed on this . Thanks, DBA
SHAMS
http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=137 and refer to the books online
about new SQL Server Agent roles, users must be a member of one or more of the following fixed database roles: SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole
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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>