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

Azure SQL Managed Instance must enforce approved authorizations for logical access to database information and system resources in accordance with applicable access control policies.

DISA Rule

SV-276226r1149587_rule

Vulnerability Number

V-276226

Group Title

SRG-APP-000033-DB-000084

Rule Version

MSQL-00-000300

Severity

CAT I

CCI(s)

CCI-000213 - Enforce approved authorizations for logical access to information and system resources in accordance with applicable access control policies.

Weight

Fix Recommendation

Use GRANT, REVOKE, DENY, ALTER SERVER ROLE … ADD MEMBER … and/or ALTER SERVER ROLE … DROP MEMBER statements to add and remove permissions on server-level securables, bringing them in line with the documented requirements.

References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/revoke-transact-sql?view=azuresqldb-current Deny:
https://docs.microsoft.com/en-us/sql/t-sql/statements/deny-transact-sql?view=azuresqldb-current DROP MEMBER:
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-droprolemember-transact-sql?view=azuresqldb-current

Check Contents

Review the system documentation to determine the required levels of protection for Azure SQL Managed Instance server securables, by type of login.

Review the permissions actually in place on the server.

Execute the supplemental "DatabasePermissions.sql" script to find permissions in place on the server.

If the actual permissions do not match the documented requirements, this is a finding.

Vulnerability Number

V-276226

Documentable

False

Rule Version

MSQL-00-000300

Severity Override Guidance

Check Content Reference

Target Key

5711