Non-Admi users accessing jobs in Enterpise Manager

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
IgorYes, but you'd have to code your own stored procedure and it would not be
called from SQL EM. You'd have to let them just execute it from Query
Analyzer or some other client-side tool.
You could always build your own Admin Interface using SQL-DMO.
Sincerely,
Anthony Thomas
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uVvyHrAAFHA.2316@.TK2MSFTNGP15.phx.gbl...
Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor