Re: Permissions on Scheduled Jobs
From: Trayce Jordan (trayce_at_jordanhome.net)
Date: 07/28/03
- Next message: Dejan Sarka: "Re: Windows authentication ?"
- Previous message: earn_at_cash.com: "EARN$£$600\week downloading free software"
- In reply to: Venkatesh: "Permissions on Scheduled Jobs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 27 Jul 2003 21:38:18 -0500
It can be done, but you have to modify certain "shipped" items from MS.
In the MSDB, under views, you would need to modify the view: SysJobs_View
and change the where clause to whatever you believe suits you best. It
could be a database role that you grant to individuals and you give them
that permission, you could eliminate the where clause altogether, etc. etc.
etc.
CREATE VIEW sysjobs_view
AS
SELECT *
FROM msdb.dbo.sysjobs
WHERE (owner_sid = SUSER_SID())
OR (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1)
OR (ISNULL(IS_MEMBER(N'TargetServersRole'), 0) = 1)
I think you'll also have to do somehting similar for executing, but I can't
remember the stored proc at the moment.
Trayce
"Venkatesh" <vaiyar@hotmail.com> wrote in message
news:0ede01c346e2$62b5f130$a101280a@phx.gbl...
> Hi
>
> I have a few Jobs that are current owned by the SQL Agent
> account. I need to allow certain users to view and
> execute these jobs. Only the DBA can view them now
> because they are running under the SQL Agent
> Administrator account. Is there a way that I can let some
> users view and execute a Job when they are still owned by
> the SQL Agent account ?
>
> Thanks,
>
> Venkatesh
- Next message: Dejan Sarka: "Re: Windows authentication ?"
- Previous message: earn_at_cash.com: "EARN$£$600\week downloading free software"
- In reply to: Venkatesh: "Permissions on Scheduled Jobs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
