Skip to content

Crunchy Data PostgreSQL Security Technical Implementation Guide

Rules, Groups, and Values defined within the XCCDF Benchmark

  • SRG-APP-000499-DB-000331

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful attempts to delete privileges/permissions occur.

    &lt;VulnDiscussion&gt;Failed attempts to change the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit...
    Rule Medium Severity
  • SRG-APP-000091-DB-000066

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must be able to generate audit records when privileges/permissions are retrieved.

    &lt;VulnDiscussion&gt;Under some circumstances, it may be useful to monitor who/what is reading privilege/permission/role information. Therefore, i...
    Rule Medium Severity
  • SRG-APP-000498-DB-000347

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful attempts to modify categorized information (e.g., classification levels/security levels) occur.

    &lt;VulnDiscussion&gt;Changes in categorized information must be tracked. Without an audit trail, unauthorized access to protected data could go un...
    Rule Medium Severity
  • SRG-APP-000507-DB-000357

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful accesses to objects occur.

    &lt;VulnDiscussion&gt;Without tracking all or selected types of access to all or selected objects (tables, views, procedures, functions, etc.), it ...
    Rule Medium Severity
  • SRG-APP-000504-DB-000354

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records for all privileged activities or other system-level access.

    &lt;VulnDiscussion&gt;Without tracking privileged activity, it would be difficult to establish, correlate, and investigate the events relating to a...
    Rule Medium Severity
  • SRG-APP-000494-DB-000345

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful attempts to access categorized information (e.g., classification levels/security levels) occur.

    &lt;VulnDiscussion&gt;Changes in categories of information must be tracked. Without an audit trail, unauthorized access to protected data could go ...
    Rule Medium Severity
  • SRG-APP-000492-DB-000332

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must be able to generate audit records when security objects are accessed.

    &lt;VulnDiscussion&gt;Changes to the security configuration must be tracked. This requirement applies to situations where security data is retriev...
    Rule Medium Severity
  • SRG-APP-000499-DB-000330

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when privileges/permissions are deleted.

    &lt;VulnDiscussion&gt;Changes in the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unautho...
    Rule Medium Severity
  • SRG-APP-000506-DB-000353

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when concurrent logons/connections by the same user from different workstations occur.

    &lt;VulnDiscussion&gt;For completeness of forensic analysis, it is necessary to track who logs on to PostgreSQL. Concurrent connections by the sam...
    Rule Medium Severity
  • SRG-APP-000501-DB-000337

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful attempts to delete security objects occur.

    &lt;VulnDiscussion&gt;The removal of security objects from the database/PostgreSQL would seriously degrade a system's information assurance posture...
    Rule Medium Severity
  • SRG-APP-000495-DB-000328

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when privileges/permissions are modified.

    &lt;VulnDiscussion&gt;Changes in the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unautho...
    Rule Medium Severity
  • SRG-APP-000504-DB-000355

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful attempts to execute privileged activities or other system-level access occur.

    &lt;VulnDiscussion&gt;Without tracking privileged activity, it would be difficult to establish, correlate, and investigate the events relating to a...
    Rule Medium Severity
  • SRG-APP-000496-DB-000334

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when security objects are modified.

    &lt;VulnDiscussion&gt;Changes in the database objects (tables, views, procedures, functions) that record and control permissions, privileges, and r...
    Rule Medium Severity
  • SRG-APP-000498-DB-000346

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when categories of information (e.g., classification levels/security levels) is modified.

    &lt;VulnDiscussion&gt;Changes in categories of information must be tracked. Without an audit trail, unauthorized access to protected data could go ...
    Rule Medium Severity
  • SRG-APP-000495-DB-000329

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful attempts to modify privileges/permissions occur.

    &lt;VulnDiscussion&gt;Failed attempts to change the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit...
    Rule Medium Severity
  • SRG-APP-000495-DB-000327

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate audit records when unsuccessful attempts to add privileges/permissions occur.

    &lt;VulnDiscussion&gt;Failed attempts to change the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit...
    Rule Medium Severity
  • SRG-APP-000175-DB-000067

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL, when utilizing PKI-based authentication, must validate certificates by performing RFC 5280-compliant certification path validation.

    &lt;VulnDiscussion&gt;The DoD standard for authentication is DoD-approved PKI certificates. A certificate's certification path is the path from th...
    Rule Medium Severity
  • SRG-APP-000097-DB-000041

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must produce audit records containing sufficient information to establish where the events occurred.

    &lt;VulnDiscussion&gt;Information system auditing capability is critical for accurate forensic analysis. Without establishing where events occurred...
    Rule Medium Severity
  • SRG-APP-000441-DB-000378

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must maintain the confidentiality and integrity of information during preparation for transmission.

    &lt;VulnDiscussion&gt;Information can be either unintentionally or maliciously disclosed or modified during preparation for transmission, including...
    Rule Medium Severity
  • SRG-APP-000089-DB-000064

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must be configured to provide audit record generation for DoD-defined auditable events within all DBMS/database components.

    &lt;VulnDiscussion&gt;Without the capability to generate audit records, it would be difficult to establish, correlate, and investigate the events r...
    Rule Medium Severity
  • SRG-APP-000375-DB-000323

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must generate time stamps, for audit records and application data, with a minimum granularity of one second.

    &lt;VulnDiscussion&gt;Without sufficient granularity of time stamps, it is not possible to adequately determine the chronological order of records....
    Rule Medium Severity
  • SRG-APP-000100-DB-000201

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must produce audit records containing sufficient information to establish the identity of any user/subject or process associated with the event.

    &lt;VulnDiscussion&gt;Information system auditing capability is critical for accurate forensic analysis. Without information that establishes the i...
    Rule Medium Severity
  • SRG-APP-000514-DB-000382

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to generate and validate cryptographic hashes.

    &lt;VulnDiscussion&gt;Use of weak or untested encryption algorithms undermines the purposes of utilizing encryption to protect data. The applicatio...
    Rule High Severity
  • SRG-APP-000416-DB-000380

    <GroupDescription></GroupDescription>
    Group
  • SRG-APP-000514-DB-000383

    <GroupDescription></GroupDescription>
    Group
  • SRG-APP-000231-DB-000154

    <GroupDescription></GroupDescription>
    Group
  • PostgreSQL must protect the confidentiality and integrity of all information at rest.

    &lt;VulnDiscussion&gt;This control is intended to address the confidentiality and integrity of information at rest in non-mobile devices and covers...
    Rule High 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