The EDB Postgres Advanced Server must generate audit records when successful logons or connections occur.
An XCCDF Rule
Description
For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to the DBMS.
- ID
- SV-259316r961824_rule
- Version
- EPAS-00-011800
- Severity
- Medium
- References
- Updated
Remediation Templates
A Manual Procedure
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()"