Title

The EDB Postgres Advanced Server must allow only the ISSM (or individuals or roles appointed by the ISSM) to select which auditable events are to be audited. (Cat II impact)

Discussion

Without the capability to restrict which roles and individuals can select which events are audited, unauthorized personnel may be able to prevent or interfere with the auditing of critical events. Suppression of auditing could permit an adversary to evade detection. Misconfigured audits can degrade the system's performance by overwhelming the audit log. Misconfigured audits may also make it more difficult to establish, correlate, and investigate the events relating to an incident or identify those responsible for one.

Check Content

Run the command "ls -al postgresql*.conf" to show file permissions. The default path for the postgresql*.conf files is /var/lib/edb/as<version>/data, but this will vary according to local circumstances. If the files are not owned by enterprisedb (user)/enterprisedb (group) or do not have RW permission for the user only, this is a finding.

Fix Text

Run these commands as the "root" user (or user with sudo privileges) from the EDB Postgres Advanced Server data (PGDATA) directory: > chown enterprisedb postgresql*.conf > chgrp enterprisedb postgresql*.conf > chmod 600 postgresql*.conf The default path for the postgresql*.conf files is /var/lib/edb/as<version>/data (PGDATA), but this will vary according to local circumstances. Run these commands as the "root" user (or user with sudo privileges) from the EDB Postgres Advanced Server data (PGDATA) directory: > chown enterprisedb postgresql*.conf > chgrp enterprisedb postgresql*.conf > chmod 600 postgresql*.conf The default path for the postgresql*.conf files is /var/lib/edb/as<version>/data (PGDATA), but this will vary according to local circumstances.

Additional Identifiers

Rule ID: SV-259215r938698_rule

Vulnerability ID: V-259215

Group Title: SRG-APP-000090-DB-000065

Expert Comments

CCIs tied to check.

Controls tied to check. These are derived from the CCIs shown above.