STIGQter: STIG Summary: Microsoft Azure SQL Managed Instance Security Technical Implementation Guide Version: 1 Release: 1 Benchmark Date: 23 Sep 2025:

The Azure SQL Managed Instance must be able to generate audit records when attempts to retrieve privileges/permissions occur.

DISA Rule

SV-276242r1150021_rule

Vulnerability Number

V-276242

Group Title

SRG-APP-000091-DB-000066

Rule Version

MSQL-00-004600

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

Deploy an Azure SQL Managed Instance audit.

Refer to the supplemental file "AzureSQLMIAudit.sql" script.

Reference: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure?view=azuresql

Check Contents

Review Azure SQL Managed Instance configuration to verify that audit records are produced when privileges/permissions/role memberships are retrieved.

To determine if an audit is configured, follow the instructions below:

Run this TSQL command to determine if SQL Auditing AuditActionGroups are configured:

SELECT DISTINCT sd.audit_action_name
FROM sys.server_audit_specification_details sd
JOIN sys.server_audit_specifications s
ON s.server_specification_id = sd.server_specification_id
WHERE s.is_state_enabled = 1
ORDER BY sd.audit_action_name

If no values exist for AuditActionGroup, this is a finding.

Verify the following AuditActionGroup(s) are configured:

SCHEMA_OBJECT_ACCESS_GROUP

If any listed AuditActionGroups do not exist in the configuration, this is a finding.

Vulnerability Number

V-276242

Documentable

False

Rule Version

MSQL-00-004600

Severity Override Guidance

Review Azure SQL Managed Instance configuration to verify that audit records are produced when privileges/permissions/role memberships are retrieved.

To determine if an audit is configured, follow the instructions below:

Run this TSQL command to determine if SQL Auditing AuditActionGroups are configured:

SELECT DISTINCT sd.audit_action_name
FROM sys.server_audit_specification_details sd
JOIN sys.server_audit_specifications s
ON s.server_specification_id = sd.server_specification_id
WHERE s.is_state_enabled = 1
ORDER BY sd.audit_action_name

If no values exist for AuditActionGroup, this is a finding.

Verify the following AuditActionGroup(s) are configured:

SCHEMA_OBJECT_ACCESS_GROUP

If any listed AuditActionGroups do not exist in the configuration, this is a finding.

Check Content Reference

M

Target Key

5711