Re: Accessing jobs in EM

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 13:54:33 -0700

There is no supported way to do this with Enterprise
Manager. The proxy account doesn't really come in to play
here. The system stored procedures involved in displaying
the job info in Enterprise Manager have checks for job owner
or sysadmin server role membership.

-Sue

On Fri, 21 Jan 2005 14:46:12 -0800, "Igor Marchenko"
<igormarchenko@hotmail.com> wrote:

>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
>

Relevant Pages

  • Re: Nevermind: Problem Between the Chair and the Keyboard
    ... There is a situation where you can end up with deleted data from Enterprise ... If you increase a constraint level in a table using Enteprise ... Manager, and then apply the script that the table designer creates, you can ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Replication Problem
    ... I've registered the Remote Computer in my Enterprise ... "SQL Server Agent on 'MyComputer' currently uses the ... how can I use Enterprise Manager ... from another computer to configure Replication Scenario's ...
    (microsoft.public.sqlserver.replication)
  • Re: Launching Enterprise Manager
    ... I uninstalled and deleted the SQL Server Enterprise ... Manager file that was causing the message. ... I cannot launch Enterprise ...
    (microsoft.public.sqlserver.setup)
  • Re: Problems with ado
    ... See if you can create a database using SQL2000 Enterprise Manager ... If none can be seen by QA => QA damaged, uninstall SQL2000 and reinstall ...
    (microsoft.public.data.ado)
  • VB6 SP6 problem with SQL 2000 Enterprise Manager
    ... Since installing SP6 I have had periodic problems with SQL 2000 Enterprise ... Manager. ... Needless to say I also have my database diagrams disappear. ...
    (microsoft.public.vb.bugs)