Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Richard Waymire » Stairway to SQL Server Agent - Level 9:...

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Rate Topic

Display Mode

Topic Options

Author

Message

Richard Waymire

Posted Saturday, October 15, 2011 3:07 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

Comments posted to this topic are about the item Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Post #1190968

george sibbald

Posted Wednesday, January 11, 2012 4:04 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 5,269, Visits: 11,203

I think its worth noting here that even members of SQAgentoperatorRole cannot modify or delete jobs they do not own.

This limitation unfortunately prevents granting the right to someone to fully manage all jobs without granting them sysadmin.

---------------------------------------------------------------------

Post #1234443

Richard Waymire

Posted Wednesday, January 11, 2012 4:06 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

Yes, unfortunately although these roles exist for the most part you need to be a sysadmin or the job owner to do anything useful.

Post #1234444

Dr. Diana Dee

Posted Sunday, January 22, 2012 9:03 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:02 PM
Points: 2,768, Visits: 108

In past versions of SQL Server, the SQL Server Agent service account needed Windows Administrator rights on the local computer in order to successfully restart the service when it stops unexpectedly (because the SQL Server Service would have to be restarted first). Is that still true in SQL Server 2008? 2012?

Thanks.

Post #1239928

Richard Waymire

Posted Wednesday, January 25, 2012 7:54 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

The SQL Server Agent service account will definately need enough rights to restart the service, I just don't know if that's full administrator rights. For some reason this limitation is not mentioned in the considerations for not using an administrative service account in books online.

Post #1241545

quackhandle1975

Posted Tuesday, March 13, 2012 5:53 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:24 AM
Points: 1,610, Visits: 590

Excellent article, great job.

qh

SQL 2K acts like a spoilt child - you need to coax it round with lollipops.

Post #1265828

« Prev Topic | Next Topic »

Permissions