The EDB Postgres Advanced Server must generate audit records when unsuccessful logons or connection attempts occur.
Severity | Group ID | Group Title | Version | Rule ID | Date | STIG Version |
|---|---|---|---|---|---|---|
| medium | V-259317 | SRG-APP-000503-DB-000351 | EPAS-00-011900 | SV-259317r961824_rule | 2024-08-27 | 2 |
Description
For completeness of forensic analysis, it is necessary to track failed attempts to log on to the DBMS. While positive identification may not be possible in a case of failed authentication, as much information as possible about the incident must be captured.
ℹ️ Check
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
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.