STIGQter: STIG Summary: MS SQL Server 2016 Database Security Technical Implementation Guide Version: 3 Release: 5 Benchmark Date: 01 Apr 2026:

SQL Server must limit privileges to change software modules, to include stored procedures, functions, and triggers, and links to software external to SQL Server.

DISA Rule

SV-213907r1167464_rule

Vulnerability Number

V-213907

Group Title

SRG-APP-000133-DB-000179

Rule Version

SQL6-D0-001200

Severity

CAT II

CCI(s)

• CCI-001499 - Limit privileges to change software resident within software libraries.

Weight

10

Fix Recommendation

Transfer ownership of database schemas to authorized database principals.

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

Check Contents

Obtain a listing of schema ownership from the server 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
WHERE p.name != 'dbo'
AND (s.name != p.name
or p.name not in
( 'db_accessadmin'
, 'db_backupoperator'
, 'db_datareader'
, 'db_datawriter'
, 'db_ddladmin'
, 'db_denydatareader'
, 'db_denydatawriter'
, 'db_owner'
, 'db_securityadmin'
, 'guest'
, 'INFORMATION_SCHEMA'
, 'sys'
, 'TargetServersRole'
, 'SQLAgentUserRole'
, 'SQLAgentReaderRole'
, 'SQLAgentOperatorRole'
, 'DatabaseMailUserRole'
, 'db_ssisadmin'
, 'db_ssisltduser'
, 'db_ssisoperator'
, 'replmonitor'
, '##MS_SSISServerCleanupJobLogin##'
)
)
ORDER BY schema_name

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

Vulnerability Number

V-213907

Documentable

False

Rule Version

SQL6-D0-001200

Severity Override Guidance

Obtain a listing of schema ownership from the server 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
WHERE p.name != 'dbo'
AND (s.name != p.name
or p.name not in
( 'db_accessadmin'
, 'db_backupoperator'
, 'db_datareader'
, 'db_datawriter'
, 'db_ddladmin'
, 'db_denydatareader'
, 'db_denydatawriter'
, 'db_owner'
, 'db_securityadmin'
, 'guest'
, 'INFORMATION_SCHEMA'
, 'sys'
, 'TargetServersRole'
, 'SQLAgentUserRole'
, 'SQLAgentReaderRole'
, 'SQLAgentOperatorRole'
, 'DatabaseMailUserRole'
, 'db_ssisadmin'
, 'db_ssisltduser'
, 'db_ssisoperator'
, 'replmonitor'
, '##MS_SSISServerCleanupJobLogin##'
)
)
ORDER BY schema_name

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

Check Content Reference

M

Target Key

3992