Help with SQL Agent Security
From: Ray Higdon (rayhigdon_at_higdonconsulting.com)
Date: 06/12/03
- Previous message: Syed Rahman: "Application Role"
- In reply to: Ben Anderson: "Help with SQL Agent Security"
- Next in thread: Ben Anderson: "Help with SQL Agent Security"
- Reply: Ben Anderson: "Help with SQL Agent Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 12 Jun 2003 02:35:31 -0700
If you have them in targetserversrole and a data reader
of MSDB, they should be able to see the history and
status.
HTH
Ray Higdon MCSE, MCDBA, CCNA
>-----Original Message-----
>Hi,
>
>I want to be able to allow certain users to see SQL
Agent
>jobs. Whilst I am aware that all I need to do is add
>them to the 'TargetServersRole', this does not allow
them
>to see the status of any jobs. This is because when
they
>look at the jobs, sp_get_composite_job_info runs a check
>to see if they are sysadmin before running
>xp_sqlagent_enum_jobs. If they aren't sysadmin the
>status just gets returned as not running (4).
>
>Is there a way round this?
>
>Thanks!
>
>Ben
>.
>
- Previous message: Syed Rahman: "Application Role"
- In reply to: Ben Anderson: "Help with SQL Agent Security"
- Next in thread: Ben Anderson: "Help with SQL Agent Security"
- Reply: Ben Anderson: "Help with SQL Agent Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
