SQLAgentUserRole
E937625
SQLAgentUserRole is a fixed database role in SQL Server that grants limited permissions for users to view and manage their own SQL Server Agent jobs without full administrative rights.
All labels observed (2)
| Label | Occurrences |
|---|---|
| SQLAgentUserRole canonical | 4 |
| SQL Server database roles | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T11655435 — 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: SQLAgentUserRole Context triple: [SQL Server Agent, hasFixedDatabaseRole, SQLAgentUserRole]
-
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.
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.
-
D.
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.
-
E.
Enterprise Manager
Enterprise Manager is an older Microsoft SQL Server administration tool that was superseded by SQL Server Management Studio for managing and developing SQL Server databases.
- 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: SQLAgentUserRole Target entity description: SQLAgentUserRole is a fixed database role in SQL Server that grants limited permissions for users to view and manage their own SQL Server Agent jobs without full administrative rights.
-
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.
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.
-
D.
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.
-
E.
Enterprise Manager
Enterprise Manager is an older Microsoft SQL Server administration tool that was superseded by SQL Server Management Studio for managing and developing SQL Server databases.
- F. None of above. chosen
Statements (46)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server security role
ⓘ
fixed database role ⓘ |
| appliesTo |
SQL Server Agent jobs
ⓘ
linked to:
SQL Server Agent
|
| availableSince |
SQL Server 2000
ⓘ
linked to:
SQL Server
|
| belongsToSecurityCategory | database-level roles ⓘ |
| canBeDropped | false ⓘ |
| canHaveMembers | true ⓘ |
| configuredBy |
ALTER ROLE ... ADD MEMBER statement
ⓘ
sp_addrolemember stored procedure ⓘ |
| controlsAccessTo |
msdb.dbo.sysjobactivity for own jobs
ⓘ
msdb.dbo.sysjobhistory for own jobs ⓘ msdb.dbo.sysjobs for own jobs ⓘ |
| definedIn |
Microsoft SQL Server
ⓘ
linked to:
SQL Server
|
| documentedIn |
Microsoft SQL Server Books Online
ⓘ
linked to:
SQL Server Books Online
|
| doesNotGrantPermission |
control SQL Server Agent service
ⓘ
manage SQL Server Agent alerts ⓘ manage SQL Server Agent operators ⓘ manage SQL Server Agent proxies ⓘ manage SQL Server Agent schedules for other users ⓘ manage jobs owned by other users ⓘ modify SQL Server Agent server-wide settings ⓘ |
| grantsPermission |
disable own SQL Server Agent jobs
ⓘ
enable own SQL Server Agent jobs ⓘ manage own SQL Server Agent jobs ⓘ receive notifications for own jobs ⓘ start own SQL Server Agent jobs ⓘ stop own SQL Server Agent jobs ⓘ view job history for own jobs ⓘ view own SQL Server Agent jobs ⓘ |
| hasPermissionScope |
job execution
ⓘ
job history viewing ⓘ job ownership ⓘ |
| hasScope | msdb database ⓘ |
| hasSecurityPurpose | principle of least privilege for job management ⓘ |
| isFixed | true ⓘ |
| isMoreLimitedThan |
SQLAgentOperatorRole
ⓘ
SQLAgentReaderRole ⓘ |
| isRecommendedFor |
application users needing to run scheduled jobs
ⓘ
developers managing only their own jobs ⓘ |
| membershipControlledBy | database administrators ⓘ |
| partOf | msdb database ⓘ |
| relatedRole |
SQLAgentOperatorRole
ⓘ
SQLAgentReaderRole ⓘ |
| requires | user account in msdb database ⓘ |
| storedIn | msdb.sys.database_principals ⓘ |
| usedFor | delegating job management to non-administrative users ⓘ |
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: SQLAgentUserRole Description of subject: SQLAgentUserRole is a fixed database role in SQL Server that grants limited permissions for users to view and manage their own SQL Server Agent jobs without full administrative rights.
Referenced by (5)
Full triples — surface form annotated when it differs from this entity's canonical label.
linked to: SQLAgentUserRole