PPS9-00-011800 - The EDB Postgres Advanced Server must generate audit records when successful logons or connections occur.

Information

For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to the DBMS.

Solution

Execute the following SQL as enterprisedb:

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: Execute the following SQL as enterprisedb:

ALTER SYSTEM SET edb_audit_connect = 'all';
ALTER SYSTEM SET edb_audit_disconnect = 'all';
SELECT pg_reload_conf();

or

Update the system documentation to note the organizationally approved setting and corresponding justification of the setting for this requirement.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_EDB_PGS_Advanced_Server_v9-6_V2R3_STIG.zip

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-12c., CAT|II, CCI|CCI-000172, Rule-ID|SV-213655r879874_rule, STIG-ID|PPS9-00-011800, STIG-Legacy|SV-83663, STIG-Legacy|V-69059, Vuln-ID|V-213655

Plugin: PostgreSQLDB

Control ID: 0bbe32b0f279f4f4b8c589382f7355bcc6803767ce5c922c00c0bf17f6ac52b1