The EDB Postgres Advanced Server must generate audit records showing starting and ending time for user access to the database(s).
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
| V-259320 | EPAS-00-012200 | SV-259320r961830_rule | Medium |
| Description |
| For completeness of forensic analysis, it is necessary to know how long a user's (or other principal's) connection to the DBMS lasts. This can be achieved by recording disconnections, in addition to logons/connections, in the audit logs. Disconnection may be initiated by the user or forced by the system (as in a timeout) or result from a system or network failure. To the greatest extent possible, all disconnections must be logged. |
| STIG | Date |
| EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide | 2024-08-27 |
Details
| Check Text (C-63059r939011_chk) |
| Execute the following SQL as the "enterprisedb" operating system user: > psql edb -c "SHOW edb_audit_connect" If the result is not "all" or if the current setting for this requirement has not been noted and approved by the organization in the system documentation, this is a finding. |
| Fix Text (F-62968r939012_fix) |
| Execute the following SQL as the "enterprisedb" operating system user: > psql edb -c "ALTER SYSTEM SET edb_audit_connect = 'all'" > psql edb -c "ALTER SYSTEM SET edb_audit_disconnect = 'all'" > psql edb -c "SELECT pg_reload_conf()" or Update the system documentation to note the organizationally approved setting and corresponding justification of the setting for this requirement. |