Re: How Someone Can View Jobs in EM That He Does Not Own
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 10/24/03
- Next message: Russell Fields: "Re: storing encryted data and full text search"
- Previous message: Russell Fields: "Re: Deleting db users via stored procedure"
- In reply to: anonymous_at_discussions.microsoft.com: "How Someone Can View Jobs in EM That He Does Not Own"
- Next in thread: Steve G.: "How Someone Can View Jobs in EM That He Does Not Own"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 24 Oct 2003 16:15:12 -0400
Yes, that works, but the downside is that a member of TargetServersRole
cannot create or modify jobs. Just so that you are warned.
Russell Fields
<anonymous@discussions.microsoft.com> wrote in message
news:017101c39a44$b3af0030$a101280a@phx.gbl...
> Hi,
>
> Try making them a member of the TargetServersRole in the
> msdb database.
>
> Regards,
>
> Tim
>
> >-----Original Message-----
> >I have a situation where someone need sthe ability to
> view
> >job information (history, etc) in Enterprise Manager, but
> >he does not own any of the jobs. How do I allow him
> >access to view these jobs?
> >
> >If I remove him from Windows administratrive rights and
> >grant him a user in the msdb database that has select
> >privs on all tables and execute privs on all stored
> >procedures, it does not allow him to view any jobs.
> >
> >The MSDN Library says you can modify jobs if you're given
> >the SQL Server-wide sysadmin role, but I would like to
> >give him lesser powers than that.
> >
> >Steve G
> >.
> >
- Next message: Russell Fields: "Re: storing encryted data and full text search"
- Previous message: Russell Fields: "Re: Deleting db users via stored procedure"
- In reply to: anonymous_at_discussions.microsoft.com: "How Someone Can View Jobs in EM That He Does Not Own"
- Next in thread: Steve G.: "How Someone Can View Jobs in EM That He Does Not Own"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
