Can any 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
Hi
If they are the owner of the job they will be able to see the job details,
but will mean that they can execute them as well. You may want to write your
own procedure to view the information.
John
"Raju" <npraju1@.hotmail.com> wrote in message
news:Oxr0p0AsFHA.2596@.TK2MSFTNGP09.phx.gbl...
> Can any 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
>
Showing posts with label admins. Show all posts
Showing posts with label admins. Show all posts
Friday, February 24, 2012
Can any please tell me how to make a user to see sql jobs.
Can any 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,
Setup a SQL Agent proxy account.
From books online:-
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.
Thanks
Hari
SQL Server MVP
"Raju" <npraju1@.hotmail.com> wrote in message
news:OSEJk0AsFHA.3720@.TK2MSFTNGP14.phx.gbl...
> Can any 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
>|||Hari,
Thank you for the response.
I tried the method, but the user can't see the list of jobs on the EM.
I want the user to stop/start the jobs, but i don't want to make him sys
admin.
Can you please help?
Thanks
Raju
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ee7%23B1PsFHA.3080@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Setup a SQL Agent proxy account.
> From books online:-
> 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.
> Thanks
> Hari
> SQL Server MVP
> "Raju" <npraju1@.hotmail.com> wrote in message
> news:OSEJk0AsFHA.3720@.TK2MSFTNGP14.phx.gbl...
>|||It won't work. When sp_help_job is executed, if a user is
not a member of the sysadmins role, they can only view jobs
they own. The proxy account doesn't come into play here.
Ownership is checked in sp_help_job that which calls
sp_get_composite_job_info. If the executing user doesn't
pass the ownership, sysadmin check, the job won't be
displayed. And if run from query analyzer, you won't get any
results back. There is no supported way to do what you want
with SQL Server 2000. One option is to add the users to the
TargetServerRole in msdb but this is not supported and the
permissions of users added to this role will vary depending
on what service pack is installed.
-Sue
On Wed, 7 Sep 2005 12:27:39 -0700, "Raju"
<npraju1@.hotmail.com> wrote:
>Hari,
>Thank you for the response.
>I tried the method, but the user can't see the list of jobs on the EM.
>I want the user to stop/start the jobs, but i don't want to make him sys
>admin.
>Can you please help?
>Thanks
>Raju
>
>"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
>news:ee7%23B1PsFHA.3080@.TK2MSFTNGP15.phx.gbl...
>fixed
>proxy
>context
>
I know sys admins can see the jobs, but i want to give access to a user who
is not sys admin.
Thanks
RajuHi,
Setup a SQL Agent proxy account.
From books online:-
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.
Thanks
Hari
SQL Server MVP
"Raju" <npraju1@.hotmail.com> wrote in message
news:OSEJk0AsFHA.3720@.TK2MSFTNGP14.phx.gbl...
> Can any 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
>|||Hari,
Thank you for the response.
I tried the method, but the user can't see the list of jobs on the EM.
I want the user to stop/start the jobs, but i don't want to make him sys
admin.
Can you please help?
Thanks
Raju
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ee7%23B1PsFHA.3080@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Setup a SQL Agent proxy account.
> From books online:-
> 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.
> Thanks
> Hari
> SQL Server MVP
> "Raju" <npraju1@.hotmail.com> wrote in message
> news:OSEJk0AsFHA.3720@.TK2MSFTNGP14.phx.gbl...
>|||It won't work. When sp_help_job is executed, if a user is
not a member of the sysadmins role, they can only view jobs
they own. The proxy account doesn't come into play here.
Ownership is checked in sp_help_job that which calls
sp_get_composite_job_info. If the executing user doesn't
pass the ownership, sysadmin check, the job won't be
displayed. And if run from query analyzer, you won't get any
results back. There is no supported way to do what you want
with SQL Server 2000. One option is to add the users to the
TargetServerRole in msdb but this is not supported and the
permissions of users added to this role will vary depending
on what service pack is installed.
-Sue
On Wed, 7 Sep 2005 12:27:39 -0700, "Raju"
<npraju1@.hotmail.com> wrote:
>Hari,
>Thank you for the response.
>I tried the method, but the user can't see the list of jobs on the EM.
>I want the user to stop/start the jobs, but i don't want to make him sys
>admin.
>Can you please help?
>Thanks
>Raju
>
>"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
>news:ee7%23B1PsFHA.3080@.TK2MSFTNGP15.phx.gbl...
>fixed
>proxy
>context
>
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.
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.
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.
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.
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
Raju
Hi
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.
I know sys admins can see the jobs, but i want to give access to a user who
is not sys admin.
Thanks
Raju
Hi
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.
Sunday, February 12, 2012
Calling webservice from a trigger
Is it possible to call/fire a method in a webservice (.asmx) from a trigger in MS SQL 2005? I would like to send out a notification to all the admins whenever a new row is inserted into a table in our db. If possible, can someone show me an example of how to?
Take a look at this post discussion - http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=57193&SiteID=17
Hope this helps
Subscribe to:
Posts (Atom)