UCF STIG Viewer Logo
Changes are coming to https://stigviewer.com. Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey

Crunchy Data Postgres 16 Security Technical Implementation Guide


Overview

Date Finding Count (111)
2024-06-17 CAT I (High): 10 CAT II (Med): 101 CAT III (Low): 0
STIG Description
This Security Technical Implementation Guide is published as a tool to improve the security of Department of Defense (DOD) information systems. The requirements are derived from the National Institute of Standards and Technology (NIST) 800-53 and related documents. Comments or proposed revisions to this document should be sent via email to the following address: disa.stig_spt@mail.mil.

Available Profiles



Findings (MAC III - Administrative Sensitive)

Finding ID Severity Title
V-261928 High PostgreSQL must use NSA-approved cryptography to protect classified information in accordance with the data owner's requirements.
V-261859 High PostgreSQL must enforce approved authorizations for logical access to information and system resources in accordance with applicable access control policies.
V-261858 High PostgreSQL must integrate with an organization-level authentication/access mechanism providing account management and automation for all users, groups, roles, and any other principals.
V-261901 High PostgreSQL must protect the confidentiality and integrity of all information at rest.
V-261882 High The PostgreSQL software installation account must be restricted to authorized users.
V-261892 High If passwords are used for authentication, PostgreSQL must transmit only encrypted representations of passwords.
V-261891 High If passwords are used for authentication, PostgreSQL must store only hashed, salted representations of passwords.
V-261896 High PostgreSQL must use NIST FIPS 140-2 or 140-3 validated cryptographic modules for cryptographic operations.
V-261894 High PostgreSQL must enforce authorized access to all PKI private keys stored/used by PostgreSQL.
V-261937 High PostgreSQL products must be a version supported by the vendor.
V-261923 Medium PostgreSQL must prohibit user installation of logic modules (stored procedures, functions, triggers, views, etc.) without explicit privileged status.
V-261922 Medium PostgreSQL must generate time stamps for audit records and application data with a minimum granularity of one second.
V-261921 Medium PostgreSQL must record time stamps in audit records and application data that can be mapped to Coordinated Universal Time (UTC), formerly Greenwich Mean Time (GMT).
V-261920 Medium PostgreSQL must provide an immediate real-time alert to appropriate support staff of all audit log failures.
V-261927 Medium PostgreSQL must require users to reauthenticate when organization-defined circumstances or situations require reauthentication.
V-261926 Medium PostgreSQL must disable network functions, ports, protocols, and services deemed by the organization to be nonsecure, in accordance with the Ports, Protocols, and Services Management (PPSM) guidance.
V-261925 Medium PostgreSQL must produce audit records of its enforcement of access restrictions associated with changes to the configuration of PostgreSQL or database(s).
V-261924 Medium PostgreSQL must enforce access restrictions associated with changes to the configuration of the DBMS or database(s).
V-261929 Medium PostgreSQL must only accept end entity certificates issued by DOD PKI or DOD-approved PKI Certification Authorities (CAs) for the establishment of all encrypted sessions.
V-261916 Medium Execution of software modules (to include stored procedures, functions, and triggers) with elevated privileges must be restricted to necessary cases only.
V-261917 Medium PostgreSQL must use centralized management of the content captured in audit records generated by all components of PostgreSQL.
V-261914 Medium PostgreSQL must enforce discretionary access control policies, as defined by the data owner, over defined subjects and objects.
V-261915 Medium PostgreSQL must prevent nonprivileged users from executing privileged functions, to include disabling, circumventing, or altering implemented security safeguards/countermeasures.
V-261912 Medium PostgreSQL must associate organization-defined types of security labels having organization-defined security label values with information in process.
V-261913 Medium PostgreSQL must associate organization-defined types of security labels having organization-defined security label values with information in transmission.
V-261910 Medium PostgreSQL must automatically terminate a user session after organization-defined conditions or trigger events requiring session disconnect.
V-261911 Medium PostgreSQL must associate organization-defined types of security labels having organization-defined security label values with information in storage.
V-261918 Medium PostgreSQL must allocate audit record storage capacity in accordance with organization-defined audit record storage requirements.
V-261919 Medium PostgreSQL must provide a warning to appropriate support staff when allocated audit record storage volume reaches 75 percent of maximum audit record storage capacity.
V-261857 Medium PostgreSQL must limit the number of concurrent sessions to an organization-defined number per user for all accounts and/or account types.
V-261862 Medium PostgreSQL must allow only the information system security manager (ISSM), or individuals or roles appointed by the ISSM, to select which events are to be audited.
V-261863 Medium PostgreSQL must be able to generate audit records when privileges/permissions are retrieved.
V-261860 Medium PostgreSQL must protect against a user falsely repudiating having performed organization-defined actions.
V-261861 Medium PostgreSQL must provide audit record generation capability for DOD-defined auditable events within all DBMS/database components.
V-261866 Medium PostgreSQL must produce audit records containing sufficient information to establish what type of events occurred.
V-261867 Medium PostgreSQL must produce audit records containing time stamps to establish when the events occurred.
V-261864 Medium PostgreSQL must generate audit records when unsuccessful attempts to retrieve privileges/permissions occur.
V-261865 Medium PostgreSQL must initiate session auditing upon startup.
V-261900 Medium PostgreSQL must maintain the authenticity of communications sessions by guarding against man-in-the-middle attacks that guess at Session ID values.
V-261903 Medium Database contents must be protected from unauthorized and unintended information transfer by enforcement of a data-transfer policy.
V-261902 Medium PostgreSQL must isolate security functions from nonsecurity functions.
V-261905 Medium PostgreSQL must check the validity of all data inputs except those specifically identified by the organization.
V-261904 Medium Access to database files must be limited to relevant processes and to authorized, administrative users.
V-261907 Medium PostgreSQL and associated applications, when making use of dynamic code execution, must scan input data for invalid values that may indicate a code injection attack.
V-261906 Medium PostgreSQL and associated applications must reserve the use of dynamic code execution for situations that require it.
V-261888 Medium Access to external executables must be disabled or restricted.
V-261889 Medium PostgreSQL must be configured to prohibit or restrict the use of organization-defined functions, ports, protocols, and/or services, as defined in the PPSM CAL and vulnerability assessments.
V-261880 Medium PostgreSQL must protect its audit features from unauthorized removal.
V-261881 Medium PostgreSQL must limit privileges to change software modules, to include stored procedures, functions and triggers, and links to software external to PostgreSQL.
V-261883 Medium Database software, including PostgreSQL configuration files, must be stored in dedicated directories, or DASD pools, separate from the host OS and other applications.
V-261884 Medium Database objects (including but not limited to tables, indexes, storage, stored procedures, functions, triggers, links to software external to the DBMS, etc.) must be owned by database/PostgreSQL principals authorized for ownership.
V-261885 Medium The 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 PostgreSQL, etc.) must be restricted to authorized users.
V-261886 Medium Unused database components, PostgreSQL software, and database objects must be removed.
V-261887 Medium Unused database components that are integrated in PostgreSQL and cannot be uninstalled must be disabled.
V-261875 Medium The audit information produced by PostgreSQL must be protected from unauthorized read access.
V-261874 Medium PostgreSQL must be configurable to overwrite audit log records, oldest first (first-in-first-out [FIFO]), in the event of unavailability of space for more audit log records.
V-261877 Medium The audit information produced by PostgreSQL must be protected from unauthorized deletion.
V-261876 Medium The audit information produced by PostgreSQL must be protected from unauthorized modification.
V-261871 Medium PostgreSQL must produce audit records containing sufficient information to establish the identity of any user/subject or process associated with the event.
V-261870 Medium PostgreSQL must produce audit records containing sufficient information to establish the outcome (success or failure) of the events.
V-261873 Medium PostgreSQL must, by default, shut down upon audit failure, to include the unavailability of space for more audit log records; or must be configurable to shut down upon audit failure.
V-261872 Medium PostgreSQL must include additional, more detailed, organization-defined information in the audit records for audit events identified by type, location, or subject.
V-261879 Medium PostgreSQL must protect its audit configuration from unauthorized modification.
V-261878 Medium PostgreSQL must protect its audit features from unauthorized access.
V-261899 Medium PostgreSQL must invalidate session identifiers upon user logout or other session termination.
V-261898 Medium PostgreSQL must separate user functionality (including user interface services) from database management functionality.
V-261893 Medium PostgreSQL, when using PKI-based authentication, must validate certificates by performing RFC 5280-compliant certification path validation.
V-261890 Medium PostgreSQL must uniquely identify and authenticate organizational users (or processes acting on behalf of organizational users).
V-261897 Medium PostgreSQL must uniquely identify and authenticate nonorganizational users (or processes acting on behalf of nonorganizational users).
V-261895 Medium PostgreSQL must map the PKI-authenticated identity to an associated user account.
V-261967 Medium PostgreSQL must offload 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 standalone systems.
V-261966 Medium PostgreSQL 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.
V-261965 Medium PostgreSQL must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to generate and validate cryptographic hashes.
V-261964 Medium PostgreSQL must generate audit records for all direct access to the database(s).
V-261963 Medium PostgreSQL must generate audit records when unsuccessful accesses to objects occur.
V-261962 Medium PostgreSQL must be able to generate audit records when successful accesses to objects occur.
V-261961 Medium PostgreSQL must generate audit records when concurrent logons/connections by the same user from different workstations occur.
V-261960 Medium PostgreSQL must generate audit records showing starting and ending time for user access to the database(s).
V-261909 Medium PostgreSQL must reveal detailed error messages only to the information system security officer (ISSO), information system security manager (ISSM), system administrator (SA), and database administrator (DBA).
V-261908 Medium PostgreSQL must provide nonprivileged users with error messages that provide information necessary for corrective actions without revealing information that could be exploited by adversaries.
V-261952 Medium PostgreSQL must generate audit records when security objects are deleted.
V-261953 Medium PostgreSQL must generate audit records when unsuccessful attempts to delete security objects occur.
V-261950 Medium PostgreSQL must generate audit records when privileges/permissions are deleted.
V-261951 Medium PostgreSQL must generate audit records when unsuccessful attempts to delete privileges/permissions occur.
V-261956 Medium PostgreSQL must generate audit records when successful logons or connections occur.
V-261957 Medium PostgreSQL must generate audit records when unsuccessful logons or connection attempts occur.
V-261954 Medium PostgreSQL must generate audit records when categories of information (e.g., classification levels/security levels) are deleted.
V-261955 Medium PostgreSQL must generate audit records when unsuccessful attempts to delete categories of information (e.g., classification levels/security levels) occur.
V-261958 Medium PostgreSQL must generate audit records for all privileged activities or other system-level access.
V-261959 Medium PostgreSQL must generate audit records when unsuccessful attempts to execute privileged activities or other system-level access occur.
V-261930 Medium PostgreSQL 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.
V-261931 Medium PostgreSQL must implement cryptographic mechanisms preventing the unauthorized disclosure of organization-defined information at rest on organization-defined information system components.
V-261932 Medium PostgreSQL must maintain the confidentiality and integrity of information during preparation for transmission.
V-261933 Medium PostgreSQL must maintain the confidentiality and integrity of information during reception.
V-261934 Medium When invalid inputs are received, PostgreSQL must behave in a predictable and documented manner that reflects organizational and system objectives.
V-261935 Medium When updates are applied to the PostgreSQL software, any software components that have been replaced or made unnecessary must be removed.
V-261936 Medium Security-relevant software updates to PostgreSQL must be installed within the time period directed by an authoritative source (e.g., IAVM, CTOs, DTMs, and STIGs).
V-261938 Medium PostgreSQL must be able to generate audit records when security objects are accessed.
V-261939 Medium PostgreSQL must generate audit records when unsuccessful attempts to access security objects occur.
V-261868 Medium PostgreSQL must produce audit records containing sufficient information to establish where the events occurred.
V-261869 Medium PostgreSQL must produce audit records containing sufficient information to establish the sources (origins) of the events.
V-261945 Medium PostgreSQL must generate audit records when unsuccessful attempts to modify privileges/permissions occur.
V-261944 Medium PostgreSQL must generate audit records when privileges/permissions are modified.
V-261947 Medium PostgreSQL must generate audit records when unsuccessful attempts to modify security objects occur.
V-261946 Medium PostgreSQL must generate audit records when security objects are modified.
V-261941 Medium PostgreSQL must generate audit records when unsuccessful attempts to access categories of information (e.g., classification levels/security levels) occur.
V-261940 Medium PostgreSQL must generate audit records when categories of information (e.g., classification levels/security levels) are accessed.
V-261943 Medium PostgreSQL must generate audit records when unsuccessful attempts to add privileges/permissions occur.
V-261942 Medium PostgreSQL must generate audit records when privileges/permissions are added.
V-261949 Medium PostgreSQL must generate audit records when unsuccessful attempts to modify categories of information (e.g., classification levels/security levels) occur.
V-261948 Medium PostgreSQL must generate audit records when categories of information (e.g., classification levels/security levels) are modified.