Skip to content

MS SQL Server 2014 Database Security Technical Implementation Guide

Rules, Groups, and Values defined within the XCCDF Benchmark

  • Database Master Key passwords must not be stored in credentials within the database.

    <VulnDiscussion>Storage of the Database Master Key password in a database credential allows decryption of sensitive data by privileged users ...
    Rule Medium Severity
  • SRG-APP-000231-DB-000154

    <GroupDescription></GroupDescription>
    Group
  • Symmetric keys (other than the database master key) must use a DoD certificate to encrypt the key.

    &lt;VulnDiscussion&gt;Data within the database is protected by use of encryption. The symmetric keys are critical for this process. If the symmetri...
    Rule Medium Severity
  • SRG-APP-000243-DB-000128

    <GroupDescription></GroupDescription>
    Group
  • SRG-APP-000033-DB-000084

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must enforce approved authorizations for logical access to information and database-level system resources in accordance with applicable access control policies.

    &lt;VulnDiscussion&gt;Authentication with a DoD-approved PKI certificate does not necessarily imply authorization to access the database and all it...
    Rule Medium Severity
  • SRG-APP-000089-DB-000064

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must generate Trace or Audit records for organization-defined auditable events.

    &lt;VulnDiscussion&gt;Audit records can be generated from various components within the information system (e.g., network interface, hard disk, mod...
    Rule Medium Severity
  • SRG-APP-000090-DB-000065

    <GroupDescription></GroupDescription>
    Group
  • In the event of a system failure, SQL Server must preserve any information necessary to return to operations with least disruption to mission processes.

    &lt;VulnDiscussion&gt;Failure to a known state can address safety or security in accordance with the mission/business needs of the organization. Th...
    Rule Medium Severity
  • SRG-APP-000231-DB-000154

    <GroupDescription></GroupDescription>
    Group
  • Where SQL Server Audit is in use at the database level, SQL Server must allow only the ISSM (or individuals or roles appointed by the ISSM) to select which auditable events are to be audited at the database level.

    &lt;VulnDiscussion&gt;Without the capability to restrict which roles and individuals can select which events are audited, unauthorized personnel ma...
    Rule Medium Severity
  • SRG-APP-000133-DB-000179

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must be monitored to discover unauthorized changes to functions.

    &lt;VulnDiscussion&gt;When dealing with change control issues, it should be noted, any changes to the hardware, software, and/or firmware component...
    Rule Medium Severity
  • SRG-APP-000133-DB-000179

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must be monitored to discover unauthorized changes to triggers.

    &lt;VulnDiscussion&gt;When dealing with change control issues, it should be noted, any changes to the hardware, software, and/or firmware component...
    Rule Medium Severity
  • SRG-APP-000133-DB-000179

    <GroupDescription></GroupDescription>
    Group
  • 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.

    &lt;VulnDiscussion&gt;When not encrypted by the Service Master Key, system administrators or application administrators may access and use the Data...
    Rule Medium Severity
  • SRG-APP-000231-DB-000154

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must be monitored to discover unauthorized changes to stored procedures.

    &lt;VulnDiscussion&gt;When dealing with change control issues, it should be noted, any changes to the hardware, software, and/or firmware component...
    Rule Medium Severity

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.

Capacity
Modules