Azure SQL Database must generate audit records for all direct access to the database(s).
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
| V-255376 | ASQL-00-015500 | SV-255376r961839_rule | CCI-000172 | medium |
| Description | ||||
| In this context, direct access is any query, command, or call to Azure SQL Database that comes from any source other than the application(s) that it supports. Examples would be the command line or a database management utility program. The intent is to capture all activity from administrative and nonstandard sources. | ||||
| STIG | Date | |||
| Microsoft Azure SQL Database Security Technical Implementation Guide | 2025-06-11 | |||
Related Frameworks
4 paths across 3 frameworks
Related Frameworks
NIST 800-531 mapping
AU-12
1.00
- DISA · V2R3 · disa_xccdf · related
- DISA · 2025-01-23 · disa_cci_list · equivalent
NIST 800-1712 mappings
3.3.1
1.00
- DISA · V2R3 · disa_xccdf · related
- DISA · 2025-01-23 · disa_cci_list · equivalent
- NIST · Rev 2 (Feb 2020, errata Jan 2021) · nist_800_171_app_d · equivalent
3.3.2
1.00
- DISA · V2R3 · disa_xccdf · related
- DISA · 2025-01-23 · disa_cci_list · equivalent
- NIST · Rev 2 (Feb 2020, errata Jan 2021) · nist_800_171_app_d · equivalent
CCI1 mapping
CCI-000172
1.00
- DISA · V2R3 · disa_xccdf · related
Details
Check Text (C-255376r961839_chk)
Review Azure SQL Database configuration to verify that audit records are produced for all direct access to the database(s).
To determine if an audit PredicateExpression (filter) exists, execute the following PowerShell script.
1. In the Azure Portal, open a Cloud Shell session.
2. Run this PowerShell command to determine the PredicateExpression:
$ResourceGroup = "myResourceGroup"
$ServerName = "myServerName"
$FormatEnumerationLimit=-1
Get-AzSqlServerAudit -ResourceGroupName $ResourceGroup -ServerName $ServerName
If a PredicateExpression is returned, review the associated filters to determine whether administrative activities are being excluded.
If any audits are configured to exclude administrative activities, this is a finding.
Fix Text (F-58993r871253_fix)
Check the system documentation for required Azure SQL Database Audits. Remove any Audit filters that exclude or reduce required auditing. Update filters to ensure administrative activity is not excluded.