Re: SQL Server Jobs - permissions for non-owners

From: Andrew Drake (andrew_drake_at_nospam.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 17:15:49 +0200

Russell Fields <RussellFields@NoMailPlease.Com> wrote in message
news:eaNuu2DYEHA.716@TK2MSFTNGP11.phx.gbl
> Andrew,
>
> There is a TargetServersRole in msdb that gives anyone in that group
> rights to looks at all jobs and job history. The downside: Someone
> in TargetServersRole cannot create or modify jobs. (We work around
> that by having them create scripts which the DBA can run to create a
> new job.)
>
> FWIW
> Russell Fields

Thanks a lot - I will try it out!

Best regards,
Andrew

Relevant Pages

  • Re: rights to view/change jobs
    ... To VIEW the jobs submitted by another user, you can put a person into the ... TargetServersRole on msdb. ... revokes the rights to create and add new jobs. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Group Access to SQL Scheduled Tasks - SQL 2000
    ... The permissions for TargetServersRole have ... adding my Windows group as a member allowed full enumeration of the SQL jobs. ... on several procs allows the target users full access to all ... is implicitly changed to this user, while the actual owner field in the job ...
    (microsoft.public.sqlserver.security)
  • Re: How Someone Can View Jobs in EM That He Does Not Own
    ... Yes, that works, but the downside is that a member of TargetServersRole ... >>he does not own any of the jobs. ... >>The MSDN Library says you can modify jobs if you're given ...
    (microsoft.public.sqlserver.security)
  • Help with SQL Agent Security
    ... If you have them in targetserversrole and a data reader ... Ray Higdon MCSE, MCDBA, CCNA ... >to see the status of any jobs. ...
    (microsoft.public.sqlserver.security)
  • Re: sysadmin priveledges
    ... "Russell Fields" wrote: ... > jobs and history, but not to create or modify jobs. ...
    (microsoft.public.sqlserver.server)