Re: Accessing jobs in EM

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

Date: Wed, 26 Jan 2005 11:46:37 -0800

Thanks a lot,Sue.
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:5f5dv0d14fq7ajas3r6qq577is20d0gn57@4ax.com...
> 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
>>>>
>>>
>>
>

Relevant Pages