RE: Rights change to allow access to view SQL Jobs

From: Gary Whitley [MSFT] (garyw_at_online.microsoft.com)
Date: 01/07/04

Next message: Jasper Smith: "Re: How can I get the last login date for a login ????"
Previous message: Kevin McDonnell [MSFT]: "RE: SQL-DMO error 126: General Error!"
In reply to: Don: "Rights change to allow access to view SQL Jobs"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Wed, 07 Jan 2004 20:25:35 GMT

Hi Don,

By design, only a member of the Sysadmin role or the owner of a job is
allowed to start and stop a specific job. This is documented in SQL Server
Books On Line in the section titled 'Creating Jobs'.

My suspicion is this constraint will not allow you to meet your objective.
Any individual user is allowed to manage only jobs owned by that user.

I do not think there is a method available that will allow us to work
around this constraint.

Thanks.

Gary

This posting is provided "AS IS" with no warranties, and confers no rights.

Next message: Jasper Smith: "Re: How can I get the last login date for a login ????"
Previous message: Kevin McDonnell [MSFT]: "RE: SQL-DMO error 126: General Error!"
In reply to: Don: "Rights change to allow access to view SQL Jobs"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: pretty basic question
... shame that is, but that's the constraint I have, so I work with it. ... You can now tell the ASP fourm people that you also heard that the owner ... A data element is ALWAYS named for what it means ... you will have multiple names for the same data ...
(microsoft.public.sqlserver.programming)
Re: pretty basic question
... shame that is, but that's the constraint I have, so I work with it. ... You can now tell the ASP fourm people that you also heard that the owner ... A data element is ALWAYS named for what it means ... you will have multiple names for the same data ...
(microsoft.public.sqlserver.programming)
Re: Changing Default Names
... If the constraint has a different owner, ... must specify the owner name when referencing the object. ... >>Kalen Delaney ... >>SQL Server MVP ...
(microsoft.public.sqlserver.server)
Re: Changing Default Names
... you will have as sysadmin) then you must specify the owner name. ... If the constraint has a> different owner, ...
(microsoft.public.sqlserver.server)
Re: Change folder owner
... Can someone shed some light on changing home directory owners from Administrator to the individual user via a script? ... (Windows 2000, Windows Server 2003, Windows XP) ... Is there a way to step through programmatically and retrieve the directories and then set the owner to the directory name? ...
(microsoft.public.windows.server.scripting)