(SQL2005) SQLAgentReaderRole-->SQL2008?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » (SQL2005) SQLAgentReaderRole-->SQL2008?

(SQL2005) SQLAgentReaderRole-->SQL2008?

Rate Topic

Display Mode

Topic Options

Author

Message

RVO

Posted Monday, December 31, 2012 1:38 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 08, 2013 1:32 PM
Points: 33, Visits: 78

Vendor documentation (for SQL 2005) says:
"assign the system administrator permission to each of the following roles:
SQLAgentUserRole,
SQLAgentReaderRole, and SQLAgentOperatorRole".
What are the equivalents of these Roles in SQL 2008?

Post #1401493

Lynn Pettis

Posted Monday, December 31, 2012 1:57 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 8:07 PM
Points: 21,633, Visits: 27,491

The same, check here: http://msdn.microsoft.com/en-us/library/ms188283(v=sql.100).aspx.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1401499

opc.three

Posted Monday, December 31, 2012 2:57 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737, Visits: 11,791

RVO (12/31/2012)

These are Database Roles in the msdb database. If you want to grant someone full access to SQL Agent jobs you only need to add them as a member of SQLAgentOperatorRole. As they are listed, each role builds on the permissions from the previous Role. i.e. SQLAgentReaderRole includes all the SQLAgentUserRole permissions and SQLAgentOperatorRole includes all the permissions of SQLAgentUserRole and SQLAgentReaderRole.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1401512

« Prev Topic | Next Topic »

Permissions