I have two standard SQL accounts that I need to give
access to view the status of jobs and the history of those
jobs through SQL Enterprise manager on a server. If I put
them in the "db_backupoperator" role they can only see the
jobs which they own. How can I create a role which will
allow them to see, start, stop and monitor jobs but not
delete, create or modify jobs.
ThanksHi 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment