SQL server

SQL agent security.

SQL 2005 has introduced granular security features with the SQL agent. Three roles are namely:

  • SQLAgentUserRole
  • SQLAgentReaderRole
  • SQLAgentOperatorRole

The permission levels in these roles are concentric. Security and user access has now become much easier to establish. These roles help when developers need access to specific part of the DB and also have need for the SQL agent. In SSMS, go to  msdb>Security>Roles>Database Roles>SqlAgentUserRole and add logins to the Role Members. Logins that only have the public server role will not be able to see the SQL agent. Using the steps above, you will now be able to grant granular access to the SQL agent. Details on the security setting of these roles can be found here (BOL).


Thinking about someting? Leave a Reply...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s