Re: Accessing jobs in EM

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

  • Next message: DBADave: "Re: BuiltinAdministrator's not SysAdmin yet appear to have DBO on" 
    Date: Tue, 25 Jan 2005 11:55:27 -0700

    Okay but just remember it's not supported though and how
    this works with this role depends on what service pack you
    are on.

    -Sue

    On Tue, 25 Jan 2005 10:39:09 -0800, "Igor Marchenko"
    <igormarchenko@hotmail.com> wrote:

    >Thanks,Sue. I have found another way:
    > 1.. Grant access to MSDB
    > 2.. Add users to the member of TargetServerRole.
    >Regards,
    >Igor
    >
    >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
    >news:lvnav0d2r3c3n64s620e9me5o0o7t1pdl6@4ax.com...
    >> 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
    >>>
    >>
    >

  • Next message: DBADave: "Re: BuiltinAdministrator's not SysAdmin yet appear to have DBO on"