STIGQter 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 limit privileges to change software modules, to include schema ownership.

DISA Rule

SV-276286r1149767_rule

Vulnerability Number

V-276286

Group Title

SRG-APP-000133-DB-000179

Rule Version

MSQL-D0-001200

Severity

CAT II

CCI(s)

Weight

10

Fix Recommendation

Transfer ownership of database schemas to authorized database principals.

ALTER AUTHORIZATION ON SCHEMA::[<Schema Name>] TO []

Check Contents

Obtain a listing of schema ownership from the instance documentation.

Execute the following query to obtain a current listing of schema ownership.

SELECT S.name AS schema_name, P.name AS owning_principal
FROM sys.schemas S
JOIN sys.database_principals P ON S.principal_id = P.principal_id
ORDER BY schema_name

If any schema is owned by an unauthorized database principal, this is a finding.

Vulnerability Number

V-276286

Documentable

False

Rule Version

MSQL-D0-001200

Severity Override Guidance

Obtain a listing of schema ownership from the instance documentation.

Execute the following query to obtain a current listing of schema ownership.

SELECT S.name AS schema_name, P.name AS owning_principal
FROM sys.schemas S
JOIN sys.database_principals P ON S.principal_id = P.principal_id
ORDER BY schema_name

If any schema is owned by an unauthorized database principal, this is a finding.

Check Content Reference

M

Target Key

5711