Re: Accessing jobs in EM

From: Igor Marchenko (igormarchenko_at_hotmail.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 10:39:09 -0800

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

Relevant Pages

  • Re: Enterprise CA options greyed out.
    ... Since you are logged in as the member of the forest root domain's domain admins group, you have the necessary permissions to write information to the Configuration Naming Context. ... server to install Cert services but still got Enterprise and Standalone. ...
    (microsoft.public.security)
  • Re: securityadmin server role - change password
    ... In Enterprise Manager (I assume that passwords are changed via ... password (e.g. member of SysAdmin or SecurityAdmin fixed server role) ... SysAdmin never have to enter the old password (i.e. the field in the ... The only exception to this rule is when a member ...
    (microsoft.public.sqlserver.setup)
  • Re: Enterprise CA options greyed out.
    ... the account is a member of the Enterprise Admins group. ... CA or Enterprise Sub on Standard edition? ...
    (microsoft.public.security)
  • Re: Cert question
    ... The server is a member of the domain? ... Enterprise CA doesn´t have anything to do with the version of server but how ... You need Windows 2003 Enterprise edition I believe to ...
    (microsoft.public.win2000.security)
  • Re: Error 22020
    ... Enterprise Manager is registered with a different login. ... >backup the database, start the agent or create new user. ... >a member of sysadmin or a member of security admin to ...
    (microsoft.public.sqlserver.security)