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