The Azure SQL Database must be able to generate audit records when privileges/permissions are retrieved.
An XCCDF Rule
Description
Under some circumstances, it may be useful to monitor who/what is reading privilege/permission/role information. Therefore, it must be possible to configure auditing to do this. DBMSs typically make such information available through views or functions. This requirement addresses explicit requests for privilege/permission/role membership information. It does not refer to the implicit retrieval of privileges/permissions/role memberships that SQL Server continually performs to determine if any and every action on the database is permitted.
- ID
- SV-255326r960885_rule
- Version
- ASQL-00-004500
- Severity
- Medium
- References
- Updated
Remediation Templates
A Manual Procedure
Deploy an audit to review the retrieval of privilege/permission/role membership information.
Refer to the supplemental file "AzureSQLDatabaseAudit.txt" PowerShell script.