SQL Server Performance Forum – Threads Archive

need to give view permissions on jobs

A new user was created and he needs to view the jobs .I removed the where clouse from msdb.sysjobsvies and it didnot worked out.Please suggest. Thanks, DBA
SHAMS

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=137 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.

]]>