Skip to content

The EDB Postgres Advanced Server must generate audit records when privileges/permissions are retrieved.

An XCCDF Rule

Description

Under some circumstances, it may be useful to monitor who/what is reading privilege/permission/role information. Therefore, it must be possible to configure auditing to do this. DBMSs typically make such information available through views or functions. This requirement addresses explicit requests for privilege/permission/role membership information. It does not refer to the implicit retrieval of privileges/permissions/role memberships that the DBMS continually performs to determine if any and every action on the database is permitted.

ID
SV-259216r960885_rule
Version
EPAS-00-001200
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_statement = 'all'"
> psql edb -c "SELECT pg_reload_conf()"

or