Re: SQL Server Jobs - permissions for non-owners
From: Andrew Drake (andrew_drake_at_nospam.com)
Date: 07/02/04
- Next message: Adam Machanic: "Re: capitalized queries shower?"
- Previous message: Day Late: "Re: Stumped - Level 16 error terminates stored proc"
- In reply to: Andrew Drake: "Re: SQL Server Jobs - permissions for non-owners"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Jul 2004 17:31:41 +0200
>> 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
[...]
>>
>> FWIW
>> Russell Fields
>
> Thanks a lot - I will try it out!
>
> Best regards,
> Andrew
Thanks again - it works!!!
Best regards,
Andrew
- Next message: Adam Machanic: "Re: capitalized queries shower?"
- Previous message: Day Late: "Re: Stumped - Level 16 error terminates stored proc"
- In reply to: Andrew Drake: "Re: SQL Server Jobs - permissions for non-owners"
- Messages sorted by: [ date ] [ thread ]