Friday, February 24, 2012

Can any one please tell me how to make a user to see sql jobs.

Can any one please tell me how to make a user to see sql jobs.
I know sys admins can see the jobs, but i want to give access to a user who
is not sys admin.
Thanks
RajuHi
This may help, from BOL:
Execute permissions for sp_help_job default to the public role in the msdb
database. A user who can execute this procedure and is a member of the
sysadmin fixed role can also create, delete, or update a job, job step, job
category, job schedule, job server, task, or job history information. 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.
When sp_help_job is invoked by a user who is a member of the sysadmin fixed
server role, sp_help_job will be executed under the security context in
which the SQL Server service is running. When the user is not a member of
the sysadmin group, sp_help_job will impersonate the SQL Server Agent proxy
account, which is specified using xp_sqlagent_proxy_account. If the proxy
account is not available, sp_help_job will fail. This is true only for
Microsoft Windows NT 4.0 and Windows 2000. On Windows 9.x, there is no
impersonation and sp_help_job is always executed under the security context
of the Windows 9.x user who started SQL Server.
John
"Raju" <npraju1@.hotmail.com> wrote in message
news:eP8SsMBsFHA.1616@.TK2MSFTNGP10.phx.gbl...
> Can any one please tell me how to make a user to see sql jobs.
> I know sys admins can see the jobs, but i want to give access to a user
> who
> is not sys admin.
> Thanks
> Raju
>|||On Fri, 2 Sep 2005 16:08:02 -0700, "Raju" <npraju1@.hotmail.com> wrote:
>Can any one please tell me how to make a user to see sql jobs.
>I know sys admins can see the jobs, but i want to give access to a user who
>is not sys admin.
You can directly query the system tables.
If there's a problem with permissions there, you might have to fool
around a bit, but should be doable.
J.

No comments:

Post a Comment