Re: Permissions to view jobs and job activity monitor

SQL Server 2005 added new database roles in msdb to address
these situations. Look at the SQLAgentReaderRole in msdb.

-Sue

On Tue, 3 Apr 2007 23:08:03 -0700, Andy
<Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi All.

I inherited operators, who monitored sql jobs running thruoghout the night.
The problem is that the previous DBA gave them full admin rights on the
server as well as making sysadmin on sql. This is a major concern to me
considering the skill level.
What I need to know is what is the minimum access permission that I can
give these people to view JOBS and JOB ACTIVITY MONITOR?


what I have done so far ...
I have revoke all permissions for these guys and given them access to the
MSDB and Master as datareader, but these still can't see the jobs

.

Relevant Pages