SV-276286r1149767_rule
V-276286
SRG-APP-000133-DB-000179
MSQL-D0-001200
CAT II
10
Transfer ownership of database schemas to authorized database principals.
ALTER AUTHORIZATION ON SCHEMA::[<Schema Name>] TO []
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.
V-276286
False
MSQL-D0-001200
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.
M
5711