December 4, 2003 at 9:03 am
Is it possible to assign a role as the owner of a job?
As I see it, I can only have a single user as the owner of a job but I want several different people to be able to run certain jobs. If I could assign the people to a role and make the role the owner of the jobs they need to run, then this would suit me fine.
Currently, when they need to run the job they log in with a single account which has appropriate privileges but due to other security 'enhancements' this account is going to disappear.
Any ideas?
Jeremy
December 9, 2003 at 8:00 am
This was removed by the editor as SPAM
December 9, 2003 at 8:15 am
Roles should be a bunch of privileges assigned to users.For a bunch of privileges to own a job may be an interesting feature.
My opinion "I am not sure roles could own a job"
Mike
December 9, 2003 at 1:19 pm
if you're talking about SQL Agent jobs, they correspond to logins (sysjobs has a sid column as a result). Since roles (at least ones we can define) are at the database level, they can't be assigned as the owner of a job.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 12, 2003 at 2:05 pm
BKelley is correct, I can't think of any reason why you would want a role to be an owner.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply