MS SQL Server 2016 Instance Security Technical Implementation Guide
Rules, Groups, and Values defined within the XCCDF Benchmark
-
SRG-APP-000504-DB-000354
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records for all privileged activities or other system-level access.
<VulnDiscussion>Without tracking privileged activity, it would be difficult to establish, correlate, and investigate the events relating to a...Rule Medium Severity -
SRG-APP-000504-DB-000355
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when unsuccessful attempts to execute privileged activities or other system-level access occur.
<VulnDiscussion>Without tracking privileged activity, it would be difficult to establish, correlate, and investigate the events relating to a...Rule Medium Severity -
SRG-APP-000505-DB-000352
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records showing starting and ending time for user access to the database(s).
<VulnDiscussion>For completeness of forensic analysis, it is necessary to know how long a user's (or other principal's) connection to SQL Ser...Rule Medium Severity -
SRG-APP-000506-DB-000353
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when concurrent logons/connections by the same user from different workstations occur.
<VulnDiscussion>For completeness of forensic analysis, it is necessary to track who logs on to SQL Server. Concurrent connections by the s...Rule Medium Severity -
SRG-APP-000507-DB-000357
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful accesses to objects occur.
<VulnDiscussion>Without tracking all or selected types of access to all or selected objects (tables, views, procedures, functions, etc.), it ...Rule Medium Severity -
SRG-APP-000508-DB-000358
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records for all direct access to the database(s).
<VulnDiscussion>In this context, direct access is any query, command, or call to SQL Server that comes from any source other than the applica...Rule Medium Severity -
SRG-APP-000514-DB-000381
<GroupDescription></GroupDescription>Group -
SQL Server must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to provision digital signatures.
<VulnDiscussion>Use of weak or untested encryption algorithms undermines the purposes of utilizing encryption to protect data. The applicatio...Rule High Severity -
SRG-APP-000514-DB-000382
<GroupDescription></GroupDescription>Group -
SQL Server must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to generate and validate cryptographic hashes.
<VulnDiscussion>Use of weak or untested encryption algorithms undermines the purposes of utilizing encryption to protect data. The applicatio...Rule High Severity -
SRG-APP-000514-DB-000383
<GroupDescription></GroupDescription>Group -
SQL Server must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to protect unclassified information requiring confidentiality and cryptographic protection, in accordance with the data owners requirements.
<VulnDiscussion>Use of weak or untested encryption algorithms undermines the purposes of utilizing encryption to protect data. The applicatio...Rule Medium Severity -
SRG-APP-000515-DB-000318
<GroupDescription></GroupDescription>Group -
The system SQL Server must off-load audit data to a separate log management facility; this must be continuous and in near real time for systems with a network connection to the storage facility and weekly or more often for stand-alone systems.
<VulnDiscussion>Information stored in one location is vulnerable to accidental or incidental deletion or alteration. Off-loading is a comm...Rule Medium Severity
Node 2
The content of the drawer really is up to you. It could have form fields, definition lists, text lists, labels, charts, progress bars, etc. Spacing recommendation is 24px margins. You can put tabs in here, and can also make the drawer scrollable.