SQLAgentOperatorRole
E939220
SQLAgentOperatorRole is a fixed database role in SQL Server that grants users broad permissions to manage and operate SQL Server Agent jobs and related automation tasks.
Statements (47)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server security role
ⓘ
fixed database role ⓘ |
| appliesTo |
SQL Server Agent alerts
ⓘ
SQL Server Agent jobs NERFINISHED ⓘ SQL Server Agent operators NERFINISHED ⓘ SQL Server Agent proxies NERFINISHED ⓘ SQL Server Agent schedules NERFINISHED ⓘ |
| bestPractice | grant only to trusted operational users ⓘ |
| category |
automation and job management role
ⓘ
database-level role ⓘ |
| definedInComponent | msdb database ⓘ |
| definedInProduct | Microsoft SQL Server NERFINISHED ⓘ |
| documentedIn | Microsoft SQL Server Books Online NERFINISHED ⓘ |
| grantsPermission |
delete SQL Server Agent jobs owned by any user
ⓘ
disable SQL Server Agent jobs ⓘ enable SQL Server Agent jobs ⓘ execute SQL Server Agent jobs ⓘ manage job alerts ⓘ manage job categories ⓘ manage job notifications ⓘ manage job schedules ⓘ manage job steps ⓘ manage operators for SQL Server Agent notifications ⓘ manage proxies for SQL Server Agent jobs ⓘ manage schedules shared across jobs ⓘ modify SQL Server Agent jobs owned by any user ⓘ respond to SQL Server Agent alerts ⓘ start SQL Server Agent jobs ⓘ stop SQL Server Agent jobs ⓘ view SQL Server Agent configuration ⓘ view SQL Server Agent error logs ⓘ view SQL Server Agent jobs ⓘ view job history for any job ⓘ |
| hasMorePrivilegesThan |
SQLAgentReaderRole
NERFINISHED
ⓘ
SQLAgentUserRole NERFINISHED ⓘ |
| introducedBy | Microsoft SQL Server Agent security design ⓘ |
| lessPrivilegedThan | sysadmin fixed server role ⓘ |
| managesFeature | SQL Server Agent NERFINISHED ⓘ |
| membershipGrantedBy | database administrator ⓘ |
| membershipStoredIn | msdb role membership metadata ⓘ |
| riskLevel | high if mis-assigned ⓘ |
| scope | msdb database only ⓘ |
| securityModel | role-based access control ⓘ |
| typicalAssignee |
DBA team members responsible for job operations
GENERATED
ⓘ
operations staff GENERATED ⓘ |
| usedFor |
day-to-day job administration
ⓘ
operational management of SQL Server Agent jobs ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.