STIGQter: STIG Summary: Microsoft Azure SQL Database Security Technical Implementation Guide Version: 2 Release: 3 Benchmark Date: 02 Jul 2025:

Azure SQL Database must generate audit records for all direct access to the database(s).

DISA Rule

SV-255376r961839_rule

Vulnerability Number

V-255376

Group Title

SRG-APP-000508-DB-000358

Rule Version

ASQL-00-015500

Severity

CAT II

CCI(s)

• CCI-000172 - Generate audit records for the event types defined in AU-2 c that include the audit record content defined in AU-3.

Weight

10

Fix Recommendation

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.

Check Contents

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.

Vulnerability Number

V-255376

Documentable

False

Rule Version

ASQL-00-015500

Severity Override Guidance

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.

Check Content Reference

M

Target Key

5500