SQLAgentReaderRole
E937626
SQLAgentReaderRole is a fixed database role in SQL Server that grants users read-only access to SQL Server Agent jobs and related metadata without allowing them to modify or execute those jobs.
Statements (48)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server security role
ⓘ
fixed database role ⓘ |
| appliesTo | SQL Server Agent subsystem NERFINISHED ⓘ |
| cannotCreate |
SQL Server Agent jobs
ⓘ
alerts ⓘ operators ⓘ proxies ⓘ |
| cannotDelete | SQL Server Agent jobs NERFINISHED ⓘ |
| cannotDisable | SQL Server Agent jobs ⓘ |
| cannotEnable | SQL Server Agent jobs NERFINISHED ⓘ |
| cannotExecute | SQL Server Agent jobs NERFINISHED ⓘ |
| cannotModify |
SQL Server Agent jobs
NERFINISHED
ⓘ
alerts ⓘ job schedules ⓘ job steps ⓘ operators ⓘ proxies ⓘ |
| cannotStart | SQL Server Agent jobs NERFINISHED ⓘ |
| cannotStop | SQL Server Agent jobs ⓘ |
| canView |
SQL Server Agent error log metadata
ⓘ
SQL Server Agent jobs NERFINISHED ⓘ alerts ⓘ job categories ⓘ job history ⓘ job properties ⓘ job schedules ⓘ job steps ⓘ operators ⓘ proxies ⓘ |
| definedIn | Microsoft SQL Server NERFINISHED ⓘ |
| grantsAccessTo | SQL Server Agent metadata ⓘ |
| hasAbbreviation | SQLAgentReader NERFINISHED ⓘ |
| hasPermissionType | read-only ⓘ |
| introducedBy | Microsoft SQL Server Agent feature NERFINISHED ⓘ |
| isContainedIn | msdb fixed database roles NERFINISHED ⓘ |
| isDocumentedIn | Microsoft SQL Server Books Online NERFINISHED ⓘ |
| isLessPrivilegedThan |
SQLAgentOperatorRole
NERFINISHED
ⓘ
SQLAgentUserRole NERFINISHED ⓘ |
| isRelatedRole |
SQLAgentOperatorRole
NERFINISHED
ⓘ
SQLAgentUserRole NERFINISHED ⓘ |
| membershipGrantedBy |
msdb database owner
ⓘ
sysadmin fixed server role ⓘ |
| primaryPurpose | grant read-only access to SQL Server Agent jobs and metadata ⓘ |
| scope | msdb database ⓘ |
| securityModel | role-based access control ⓘ |
| typicalUseCase |
auditing SQL Server Agent jobs
ⓘ
monitoring SQL Server Agent job status ⓘ reviewing job configuration without modification rights ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.