The EDB Postgres Advanced Server must generate audit records when successful logons or connections occur.
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
| V-259316 | EPAS-00-011800 | SV-259316r961824_rule | CCI-000172 | medium |
| Description | ||||
| For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to the DBMS. | ||||
| STIG | Date | |||
| EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide | 2024-08-27 | |||
Details
Check Text (C-259316r961824_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-62964r939000_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.