December 31, 2012 at 1:38 pm
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?
December 31, 2012 at 1:57 pm
The same, check here: http://msdn.microsoft.com/en-us/library/ms188283(v=sql.100).aspx.
December 31, 2012 at 2:57 pm
RVO (12/31/2012)
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?
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply