STIGQter STIGQter: STIG Summary: MS SQL Server 2016 Database Security Technical Implementation Guide

Version: 1

Release: 5 Benchmark Date: 24 Jan 2020

CheckedNameTitle
SV-93767r1_ruleSQL Server databases must integrate with an organization-level authentication/access mechanism providing account management and automation for all users, groups, roles, and any other principals.
SV-93771r1_ruleSQL Server must enforce approved authorizations for logical access to information and system resources in accordance with applicable access control policies.
SV-93773r3_ruleSQL Server must protect against a user falsely repudiating by ensuring only clearly unique Active Directory user accounts can connect to the database.
SV-93775r2_ruleSQL Server must protect against a user falsely repudiating by use of system-versioned tables (Temporal Tables).
SV-93777r3_ruleSQL Server must protect against a user falsely repudiating by ensuring databases are not in a trust relationship.
SV-93779r1_ruleSQL Server must allow only the ISSM (or individuals or roles appointed by the ISSM) to select which auditable events are to be audited.
SV-93781r1_ruleSQL Server must limit privileges to change software modules, to include stored procedures, functions, and triggers.
SV-93783r1_ruleSQL Server must limit privileges to change software modules, to include stored procedures, functions, and triggers, and links to software external to SQL Server.
SV-93785r1_ruleDatabase 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.
SV-93787r1_ruleThe role(s)/group(s) used to modify database structure (including but not necessarily 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.
SV-93789r1_ruleIn 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.
SV-93791r2_ruleThe Database Master Key encryption password must meet DOD password complexity requirements.
SV-93793r1_ruleThe 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.
SV-93795r1_ruleThe Certificate used for encryption must be backed up, stored offline and off-site.
SV-93797r1_ruleSQL Server must isolate security functions from non-security functions.
SV-93799r1_ruleDatabase contents must be protected from unauthorized and unintended information transfer by enforcement of a data-transfer policy.
SV-93801r1_ruleSQL Server must check the validity of all data inputs except those specifically identified by the organization.
SV-93803r1_ruleSQL Server must provide non-privileged users with error messages that provide information necessary for corrective actions without revealing information that could be exploited by adversaries.
SV-93805r1_ruleSQL Server must associate organization-defined types of security labels having organization-defined security label values with information in storage.
SV-93807r1_ruleSQL Server must associate organization-defined types of security labels having organization-defined security label values with information in process.
SV-93809r1_ruleSQL Server must associate organization-defined types of security labels having organization-defined security label values with information in transmission.
SV-93811r1_ruleSQL Server must enforce discretionary access control policies, as defined by the data owner, over defined subjects and objects.
SV-93813r2_ruleExecution of stored procedures and functions that utilize execute as must be restricted to necessary cases only.
SV-93815r1_ruleSQL Server must prohibit user installation of logic modules (stored procedures, functions, triggers, views, etc.) without explicit privileged status.
SV-93817r2_ruleSQL Server must enforce access restrictions associated with changes to the configuration of the database(s).
SV-93819r2_ruleSQL Server must use NSA-approved cryptography to protect classified information in accordance with the data owners requirements.
SV-93821r1_ruleSQL Server must implement cryptographic mechanisms to prevent unauthorized modification of organization-defined information at rest (to include, at a minimum, PII and classified information) on organization-defined information system components.
SV-93823r1_ruleSQL Server must implement cryptographic mechanisms preventing the unauthorized disclosure of organization-defined information at rest on organization-defined information system components.