STIGQter: STIG Summary: Microsoft SQL Server 2022 Database Security Technical Implementation Guide Version: 1 Release: 3 Benchmark Date: 01 Apr 2026:

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

DISA Rule

SV-271119r1137654_rule

Vulnerability Number

V-271119

Group Title

SRG-APP-000033-DB-000084

Rule Version

SQLD-22-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

Configure SQL Server settings and access controls to permit user access only to objects and data that the user is authorized to view or interact with, and to prevent access to all other objects and data.

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

Check Contents

If the database is tempdb, this is Not Applicable.

Check SQL Server settings to determine whether users are restricted from accessing objects and data they are not authorized to access.

Review the system documentation to determine the required levels of protection for securables in the database by type of user.

Review the permissions in place in the database.

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

Use the supplemental file "Database permission assignments to users and roles.sql".

Vulnerability Number

V-271119

Documentable

False

Rule Version

SQLD-22-000300

Severity Override Guidance

Check Content Reference

Target Key

5676