The EDB Postgres Advanced Server must protect its audit features from unauthorized removal.

Severity	Group ID	Group Title	Version	Rule ID	Date	STIG Version
medium	V-259233	SRG-APP-000123-DB-000204	EPAS-00-003100	SV-259233r960945_rule	2024-08-27	2

Description
Protecting audit data also includes identifying and protecting the tools used to view and manipulate log data. Therefore, protecting audit tools is necessary to prevent unauthorized operation on audit data. Applications providing tools to interface with audit data will leverage user permissions and roles identifying the user accessing the tools and the corresponding rights the user enjoys in order make access decisions regarding the deletion of audit tools. Audit tools include, but are not limited to, vendor-provided and open source audit tools needed to successfully view and manipulate audit information system activity and records. Audit tools include custom queries and report generators.

Description

Protecting audit data also includes identifying and protecting the tools used to view and manipulate log data. Therefore, protecting audit tools is necessary to prevent unauthorized operation on audit data. Applications providing tools to interface with audit data will leverage user permissions and roles identifying the user accessing the tools and the corresponding rights the user enjoys in order make access decisions regarding the deletion of audit tools. Audit tools include, but are not limited to, vendor-provided and open source audit tools needed to successfully view and manipulate audit information system activity and records. Audit tools include custom queries and report generators.

ℹ️ Check
Verify User ownership, Group ownership, and permissions on the "edb_audit" directory: > ls -ld <path-to-data-directory>/edb_audit If the User owner is not "enterprisedb", this is a finding. If the Group owner is not "enterprisedb", this is a finding. If the directory is more permissive than 700, this is a finding. The default path for the edb_audit directory is /var/lib/edb/as<version>/data (PGDATA), but this will vary according to local circumstances.

ℹ️ Check

Verify User ownership, Group ownership, and permissions on the "edb_audit" directory: > ls -ld <path-to-data-directory>/edb_audit If the User owner is not "enterprisedb", this is a finding. If the Group owner is not "enterprisedb", this is a finding. If the directory is more permissive than 700, this is a finding. The default path for the edb_audit directory is /var/lib/edb/as<version>/data (PGDATA), but this will vary according to local circumstances.

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