SQLD-22-000100 - SQL Server must integrate with an organization-level authentication/access mechanism providing account management and automation for all users, groups, roles, and any other principals.

CAT|I

CCI|CCI-000015

Rule-ID|SV-271118r1107970_rule

STIG-ID|SQLD-22-000100

Vuln-ID|V-271118

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

CCI|CCI-000213

Rule-ID|SV-271119r1107973_rule

STIG-ID|SQLD-22-000300

Vuln-ID|V-271119

SQLD-22-000500 - SQL Server must protect against a user falsely repudiating by using system-versioned tables (Temporal Tables).

CAT|II

CCI|CCI-000166

Rule-ID|SV-271121r1109177_rule

STIG-ID|SQLD-22-000500

Vuln-ID|V-271121

SQLD-22-000600 - SQL Server must protect against a user falsely repudiating by ensuring databases are not in a trust relationship.

Rule-ID|SV-271122r1109180_rule

STIG-ID|SQLD-22-000600

Vuln-ID|V-271122

SQLD-22-000700 - SQL Server must allow only the information system security manager (ISSM) (or individuals or roles appointed by the ISSM) to select which auditable events are to be audited.

CCI|CCI-000171

Rule-ID|SV-271124r1109215_rule

STIG-ID|SQLD-22-000700

Vuln-ID|V-271124

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

CCI|CCI-001499

Rule-ID|SV-271143r1108045_rule

STIG-ID|SQLD-22-001200

Vuln-ID|V-271143

SQLD-22-001300 - Database objects (including but not limited to tables, indexes, storage, stored procedures, functions, triggers, links to software external to SQL Server, etc.) must be owned by database/DBMS principals authorized for ownership.

Rule-ID|SV-271146r1109183_rule

STIG-ID|SQLD-22-001300

Vuln-ID|V-271146

SQLD-22-001400 - The role(s)/group(s) used to modify database structure (including but not limited to tables, indexes, storage, etc.) and logic modules (stored procedures, functions, triggers, links to software external to SQL Server, etc.) must be restricted to authorized users.

CCI|CCI-003980

Rule-ID|SV-271147r1111078_rule

STIG-ID|SQLD-22-001400

Vuln-ID|V-271147

SQLD-22-001500 - In the event of a system failure, hardware loss or disk failure, SQL Server must be able to restore necessary databases with least disruption to mission processes.

CCI|CCI-001665

Rule-ID|SV-271168r1109218_rule

STIG-ID|SQLD-22-001500

Vuln-ID|V-271168

SQLD-22-001600 - The Database Master Key encryption password must meet DOD password complexity requirements.

CCI|CCI-001199

Rule-ID|SV-271169r1109188_rule

STIG-ID|SQLD-22-001600

Vuln-ID|V-271169

SQLD-22-001700 - The Database Master Key must be encrypted by the Service Master Key, where a Database Master Key is required and another encryption method has not been specified.

Rule-ID|SV-271170r1109190_rule

STIG-ID|SQLD-22-001700

Vuln-ID|V-271170

SQLD-22-001800 - The certificate used for encryption must be backed up and stored in a secure location that is not on the SQL Server.

Rule-ID|SV-271171r1109192_rule

STIG-ID|SQLD-22-001800

Vuln-ID|V-271171

SQLD-22-001900 - SQL Server must isolate security functions from nonsecurity functions.

CCI|CCI-001084

Rule-ID|SV-271172r1109195_rule

STIG-ID|SQLD-22-001900

Vuln-ID|V-271172

SQLD-22-002000 - Database contents must be protected from unauthorized and unintended information transfer by enforcement of a data transfer policy.

CCI|CCI-001090

Rule-ID|SV-271173r1109197_rule

STIG-ID|SQLD-22-002000

Vuln-ID|V-271173

SQLD-22-002100 - SQL Server must check the validity of all data inputs except those specifically identified by the organization.

CCI|CCI-001310

Rule-ID|SV-271176r1109200_rule

STIG-ID|SQLD-22-002100

Vuln-ID|V-271176

SQLD-22-002400 - SQL Server must provide nonprivileged users with error messages that provide information necessary for corrective actions without revealing information that could be exploited by adversaries.

CCI|CCI-001312

Rule-ID|SV-271179r1108921_rule

STIG-ID|SQLD-22-002400

Vuln-ID|V-271179

SQLD-22-002600 - SQL Server must associate organization-defined types of security labels having organization-defined security label values with information in process, transit, or storage.

CCI|CCI-002262

CCI|CCI-002263

CCI|CCI-002264

Rule-ID|SV-271184r1109203_rule

STIG-ID|SQLD-22-002600

Vuln-ID|V-271184

SQLD-22-002800 - SQL Server must enforce discretionary access control (DAC) policies, as defined by the data owner, over defined subjects and objects.

CCI|CCI-002165

Rule-ID|SV-271186r1109206_rule

STIG-ID|SQLD-22-002800

Vuln-ID|V-271186

SQLD-22-002900 - Execution of stored procedures and functions that use execute as must be restricted to necessary cases only.

CCI|CCI-002233

Rule-ID|SV-271188r1108912_rule

STIG-ID|SQLD-22-002900

Vuln-ID|V-271188

SQLD-22-003100 - SQL Server must enforce access restrictions associated with changes to the configuration of the database(s).

CCI|CCI-001813

Rule-ID|SV-271195r1109208_rule

STIG-ID|SQLD-22-003100

Vuln-ID|V-271195

SQLD-22-003200 - SQL Server must use NSA-approved cryptography to protect classified information in accordance with the data owner's requirements.

CCI|CCI-002450

Rule-ID|SV-271199r1108919_rule

STIG-ID|SQLD-22-003200

Vuln-ID|V-271199

SQLD-22-003300 - SQL Server must implement cryptographic mechanisms to prevent unauthorized modification or disclosure of organization-defined information at rest (to include, at a minimum, PII and classified information) on organization-defined information system components.

CCI|CCI-002475

CCI|CCI-002476

Rule-ID|SV-271201r1109210_rule

STIG-ID|SQLD-22-003300

Vuln-ID|V-271201

Detections

Analytics

DISA Microsoft SQL Server 2022 Database STIG v1r1

Warning! Audit Deprecated

Audit Details

File Details

Audit Changelog

Revision 1.1

Miscellaneous