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.
All labels observed (2)
| Label | Occurrences |
|---|---|
| SQLAgentReaderRole canonical | 4 |
| SQLAgentReader | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T11655436 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: SQLAgentReaderRole Context triple: [SQL Server Agent, hasFixedDatabaseRole, SQLAgentReaderRole]
-
A.
SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
-
B.
DBA
DBA is the commonly used acronym for the Dallas Bar Association, a professional organization of lawyers in Dallas, Texas.
-
C.
Read-Only Domain Controller
A Read-Only Domain Controller (RODC) is a type of Active Directory domain controller that hosts a read-only copy of the directory database to enhance security and performance in branch or untrusted locations.
-
D.
Directory System Agent
The Directory System Agent is a core component in X.500 directory services responsible for managing and providing access to directory information on behalf of clients and other directory servers.
-
E.
SQL Server Authentication
SQL Server Authentication is a SQL Server login method that uses credentials stored and validated by the database engine itself rather than relying on Windows accounts.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: SQLAgentReaderRole Target entity description: 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.
-
A.
SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
-
B.
DBA
DBA is the commonly used acronym for the Dallas Bar Association, a professional organization of lawyers in Dallas, Texas.
-
C.
Read-Only Domain Controller
A Read-Only Domain Controller (RODC) is a type of Active Directory domain controller that hosts a read-only copy of the directory database to enhance security and performance in branch or untrusted locations.
-
D.
Directory System Agent
The Directory System Agent is a core component in X.500 directory services responsible for managing and providing access to directory information on behalf of clients and other directory servers.
-
E.
SQL Server Authentication
SQL Server Authentication is a SQL Server login method that uses credentials stored and validated by the database engine itself rather than relying on Windows accounts.
- F. None of above. chosen
Statements (48)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server security role
ⓘ
fixed database role ⓘ |
| appliesTo |
SQL Server Agent subsystem
ⓘ
linked to:
SQL Server Agent
|
| cannotCreate |
SQL Server Agent jobs
ⓘ
alerts ⓘ operators ⓘ proxies ⓘ |
| cannotDelete |
SQL Server Agent jobs
ⓘ
linked to:
SQL Server Agent
|
| cannotDisable | SQL Server Agent jobs ⓘ |
| cannotEnable |
SQL Server Agent jobs
ⓘ
linked to:
SQL Server Agent
|
| cannotExecute |
SQL Server Agent jobs
ⓘ
linked to:
SQL Server Agent
|
| cannotModify |
SQL Server Agent jobs
ⓘ
linked to:
SQL Server Agent
alerts ⓘ job schedules ⓘ job steps ⓘ operators ⓘ proxies ⓘ |
| cannotStart |
SQL Server Agent jobs
ⓘ
linked to:
SQL Server Agent
|
| cannotStop | SQL Server Agent jobs ⓘ |
| canView |
SQL Server Agent error log metadata
ⓘ
SQL Server Agent jobs ⓘ
linked to:
SQL Server Agent
alerts ⓘ job categories ⓘ job history ⓘ job properties ⓘ job schedules ⓘ job steps ⓘ operators ⓘ proxies ⓘ |
| definedIn |
Microsoft SQL Server
ⓘ
linked to:
SQL Server
|
| grantsAccessTo | SQL Server Agent metadata ⓘ |
| hasAbbreviation |
SQLAgentReader
ⓘ
linked to:
SQLAgentReaderRole
|
| hasPermissionType | read-only ⓘ |
| introducedBy |
Microsoft SQL Server Agent feature
ⓘ
linked to:
SQL Server Agent
|
| isContainedIn | msdb fixed database roles ⓘ |
| isDocumentedIn |
Microsoft SQL Server Books Online
ⓘ
linked to:
SQL Server Books Online
|
| isLessPrivilegedThan |
SQLAgentOperatorRole
ⓘ
SQLAgentUserRole ⓘ |
| isRelatedRole |
SQLAgentOperatorRole
ⓘ
SQLAgentUserRole ⓘ |
| 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 ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: SQLAgentReaderRole Description of subject: 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.
Referenced by (5)
Full triples — surface form annotated when it differs from this entity's canonical label.
linked to: SQLAgentReaderRole