EPAS-00-002100 - The EDB Postgres Advanced Server must produce audit records containing sufficient information to establish the identity of any user/subject or process associated with the event.

Information

Information system auditing capability is critical for accurate forensic analysis. Without information that establishes the identity of the subjects (i.e., users or processes acting on behalf of users) associated with the events, security personnel cannot determine responsibility for the potentially harmful event.

Identifiers (if authenticated or otherwise known) include, but are not limited to, user database tables, primary key values, user names, or process identifiers.

Solution

Execute the following SQL as the 'enterprisedb' operating system user:

> psql edb -c 'ALTER SYSTEM SET edb_audit_statement = '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.

Item Details

Audit Name: EnterpriseDB PostgreSQL Advanced Server DB v2r1

Category: AUDIT AND ACCOUNTABILITY

Plugin: PostgreSQLDB

Control ID: 58efd8405fc82efd2452f8961c0151f40fa5a8dcb30e44794caf3769eddf0d4a

Detections

Analytics

EPAS-00-002100 - The EDB Postgres Advanced Server must produce audit records containing sufficient information to establish the identity of any user/subject or process associated with the event.

Information

Solution

See Also

Item Details