Skip to content

MS SQL Server 2016 Instance Security Technical Implementation Guide

Rules, Groups, and Values defined within the XCCDF Benchmark

  • SRG-APP-000454-DB-000389

    Group
  • SRG-APP-000456-DB-000390

    Group
  • SRG-APP-000492-DB-000332

    Group
  • SRG-APP-000494-DB-000345

    Group
  • SQL Server must generate audit records when successful and unsuccessful attempts to access categorized information (e.g., classification levels/security levels) occur.

    Changes in categorized information must be tracked. Without an audit trail, unauthorized access to protected data could go undetected. For detailed information on categorizing information, refer...
    Rule Medium Severity
  • SRG-APP-000495-DB-000327

    Group
  • SRG-APP-000495-DB-000329

    Group
  • SRG-APP-000496-DB-000335

    Group
  • SQL Server must generate audit records when successful and unsuccessful attempts to modify security objects occur.

    Changes in the database objects (tables, views, procedures, functions) that record and control permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail,...
    Rule Medium Severity
  • SRG-APP-000498-DB-000347

    Group
  • SQL Server must generate audit records when successful and unsuccessful attempts to modify categorized information (e.g., classification levels/security levels) occur.

    Changes in categories of information must be tracked. Without an audit trail, unauthorized access to protected data could go undetected. To aid in diagnosis, it is necessary to keep track of fai...
    Rule Medium Severity
  • SRG-APP-000499-DB-000331

    Group
  • SRG-APP-000501-DB-000337

    Group
  • SQL Server must generate audit records when successful and unsuccessful attempts to delete security objects occur.

    The removal of security objects from the database/DBMS would seriously degrade a system's information assurance posture. If such an action is attempted, it must be logged. To aid in diagnosis, i...
    Rule Medium Severity
  • SRG-APP-000502-DB-000349

    Group
  • SRG-APP-000503-DB-000351

    Group
  • SQL Server must generate audit records when successful and unsuccessful logons or connection attempts occur.

    For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to SQL Server. It is also necessary to track failed attempts to log on to SQL Server. Wh...
    Rule Medium Severity
  • SRG-APP-000504-DB-000354

    Group
  • SRG-APP-000504-DB-000355

    Group
  • SRG-APP-000505-DB-000352

    Group

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