Friday , June 18 2021

SQL Server Agent Fixed Database Roles

A login must have authority over some database roles in the msdb database in order to access SQL Server Agent. These roles in the msdb database are as follows.

  • SQLAgentUserRole
  • SQLAgentReaderRole
  • SQLAgentOperatorRole

If a login is authorized in any of the above database roles or if it is sysadmin, it can see SQL Server Agent on SSMS. Let’s explain these roles.

SQLAgentUserRole: This role is the least authorized role of the SQL Server Agent database roles. The following table that I have copy from msdn shows the operations that a login with this role can do. For detailed information about operators and proxies, please refer to the following articles.

How To Create An Operator On SQL Server“,

Run Your Jobs With a Proxy Account

SQLAgentReaderRole: This role has the full authority of SQLAgentUserRole. There are some extra privileges. You can see the details in the following link.

SQLAgentOperatorRole: This role has the full authority of SQLAgentReaderRole. There are some extra privileges.

You can see the details in the following link.

Source: https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-server-2017

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *