NIST SP 800-53 Rev. 5 · Access Control
AC-6(7) on Microsoft Sentinel
Privileged role without documented ownership — a published KQL query you can run against Microsoft Sentinel / Log Analytics, with the evidence it needs, the settings you decide, and what a result does and does not establish.
Why this matters
Powerful access that nobody in the organization owns or has reviewed
Someone grants a colleague elevated access to solve an urgent problem. Years later the access is still there, the colleague has changed roles twice, and nobody can say who approved it or why. Organizations are expected to review privileged access periodically, but a review needs a list of who is accountable for each grant, and that list is usually the thing that was never written down.
Why this check earns its place. It reports the absence of a record rather than a technical fault. That is a different kind of finding, and it is the one that makes the periodic review possible at all.
- What it reads
- The organization's own register of administrative roles and who is accountable for each.
- What it reports
- Administrative roles with no named owner, no recorded reason for existing, or a review that is overdue.
See related public disclosures on the Signals page →
What this finds
Privileged role lacking a documented owner or justification, or overdue for its required review.
The requirement
The organization must review the privileges assigned to users at an organization-defined frequency to validate the need for such privileges, and reassign or remove privileges when no longer appropriate.
NIST SP 800-53 Rev. 5 — AC-6(7) (Least Privilege | Review of User Privileges).
NIST requires periodic validation of privilege need. Whether that is evidenced by an owner field, a ticket reference, or a signed attestation is an organization-defined implementation choice. A missing field is evidence about the record, not proof about the access.
How this maps to the CISA performance goals
The Cross-Sector Cybersecurity Performance Goals are a voluntary baseline published by CISA — the U.S. federal agency for critical-infrastructure cybersecurity — written for organizations too small to employ security staff. This control speaks to:
- 3.H — Implement the principles of least privilege
A privileged role nobody owns cannot be justified as the minimum necessary. - 3.G — Administrators maintain separate user and privileged accounts (partial — see note)
Related to separating administrative identity, but the pack checks ownership of the role, not whether admins hold a second account.
See the full coverage map, including the goals no query can answer →
Evidence this query needs
Privileged role register privileged_role_register.csv
Defines which roles your organisation treats as privileged, who owns each one, and how often it must be reviewed. Cloud platforms know which roles exist; only you know which ones matter and who is accountable for them.
Minimum fields: role_name, platform, privilege_classification
Three fields make the staleness and MFA checks work. The ownership fields are what make AC-6(7) answerable at all — without them that check has nothing to test against.
The query
Published as ac-6-7-unowned-role.azure.kql. Reads PrivilegedRoleRegister (watchlist). Requires: Log Analytics Reader; Sentinel Reader for watchlists.
Before this returns anything,
PrivilegedRoleRegister (watchlist) has to be landed there. If not, the query reports nothing found — which looks
exactly like nothing wrong. What has to be switched on first →
// AC-6(7) -- privileged roles lacking ownership evidence or overdue for review
let DefaultCycleDays = 90;
_GetWatchlist('PrivilegedRoleRegister')
| where platform =~ "azure"
| extend RoleName = tostring(role_name),
Owner = tostring(documented_owner),
Justify = tostring(business_justification),
CycleDays = toint(coalesce(toint(review_cycle_days), DefaultCycleDays)),
LastReview = todatetime(last_review_date)
| extend DaysSinceReview = iff(isnull(LastReview), 9999,
datetime_diff('day', now(), LastReview))
| extend MissingOwner = isempty(Owner),
MissingJustify = isempty(Justify),
ReviewOverdue = DaysSinceReview > CycleDays
| where MissingOwner or MissingJustify or ReviewOverdue
| extend Gap = strcat(
iff(MissingOwner, "no documented owner; ", ""),
iff(MissingJustify, "no business justification; ", ""),
iff(ReviewOverdue, strcat("review overdue by ",
tostring(DaysSinceReview - CycleDays), " days", ""), ""))
| project RoleName, Owner, Justify, LastReview, CycleDays,
DaysSinceReview, Gap, SourceSystem = "Microsoft Entra ID (PIM)"
| order by DaysSinceReview descOpen this pack on Microsoft Sentinel to adjust the settings and download it →
The interactive version opens on Microsoft Sentinel — the platform on this page — even if your environment profile does not list it.
Settings you decide
NIST states the objective and leaves these to your organization. The interactive version of this pack applies them to the query for you.
- Default review cycle (days) (default 90)
- Applied to roles whose register entry does not specify its own review cycle.
Running it continuously
Sentinel scheduled analytics rule
Rule type: Scheduled query rule
Run frequency: Every 12 hours
Lookup period: n/a (evaluates the register directly)
Trigger: Number of query results > 0
Entity mapping: CloudApplication -> RoleName
Severity: Medium
Incident: Create incident, group by RoleName
Suppression: None -- each role reviewed individuallySuppression is deliberately off: every role missing ownership is a separate reviewable item, and collapsing them would hide roles registered in the same window.
What a result does not prove
A missing field is evidence about the completeness of the register, not proof that the access itself is inappropriate. Documentation may exist outside the queried source.
Validation status for this platform: Not tenant-validated. Structure, query generation, and preflight are covered by the project's automated test suites. This pack has not been executed against a live tenant, account, or index. Validate it in a non-production scope before relying on any result.
Before you act on a result
- Is the ownership evidence recorded somewhere this query does not read?
- Was this an emergency assignment following a separate documented process?
- Does the role remain necessary in its current form?
- Who will attest to this privilege at the next review cycle?
Common questions
- How do I check for privileged role without documented ownership in Microsoft Sentinel?
- Run the published KQL query on this page against Microsoft Sentinel / Log Analytics. It reads PrivilegedRoleRegister (watchlist) and reports: Privileged role lacking a documented owner or justification, or overdue for its required review.
- What permissions are needed to run this Microsoft Sentinel query?
- Log Analytics Reader; Sentinel Reader for watchlists.
- What evidence does AC-6(7) need that Microsoft Sentinel cannot produce?
- Privileged role register (privileged_role_register.csv). Defines which roles your organisation treats as privileged, who owns each one, and how often it must be reviewed. Cloud platforms know which roles exist; only you know which ones matter and who is accountable for them. At minimum it must carry: role_name, platform, privilege_classification.
- Does a result from this query mean the control has failed?
- A missing field is evidence about the completeness of the register, not proof that the access itself is inappropriate. Documentation may exist outside the queried source.
Terms used on this page
- NIST SP 800-53the U.S. federal catalogue of security requirements
- The catalogue of security and privacy requirements published by the National Institute of Standards and Technology, a U.S. federal agency. U.S. government systems are measured against it, and many private organizations adopt it voluntarily. Each requirement has an identifier such as AC-2. Official source →
- CISACybersecurity and Infrastructure Security Agency
- The U.S. federal agency responsible for national critical-infrastructure cybersecurity. Its publications are works of the U.S. government and are free to use. Official source →
- KQLKusto Query Language
- The language used to ask questions of data held in Microsoft Sentinel. A query written in it is text, like a spreadsheet formula, and can be read before it is run.
- CPGCross-Sector Cybersecurity Performance Goals
- A voluntary baseline of security practices published by the U.S. Cybersecurity and Infrastructure Security Agency, written specifically for organizations too small to employ security staff. It is a short, plainly written starting list rather than a full standard. Official source →
- not tenant-validatednever executed against real data
- The check has passed the project's automated tests for structure and syntax, but has never been run against real data anywhere. Test it in a safe scope before relying on any result.
The same control on other platforms
- AC-6(7) on AWS — SQL (Athena) + Lambda
- AC-6(7) on Splunk — SPL
- All platforms for AC-6(7)