Access to database files must be limited to relevant processes and to authorized, administrative users.

Severity	Group ID	Group Title	Version	Rule ID	Date	STIG Version
medium	V-259262	SRG-APP-000243-DB-000374	EPAS-00-006100	SV-259262r961149_rule	2024-08-27	2

Description
Applications, including DBMSs, must prevent unauthorized and unintended information transfer via shared system resources. Permitting only DBMS processes and authorized, administrative users to have access to the files where the database resides helps ensure that those files are not shared inappropriately and are not open to backdoor access and manipulation.

ℹ️ Check
Verify User ownership, Group ownership, and permissions on the <postgresql data directory> directory: > ls -ald <PostgreSQL data directory> 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 postgresql data 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 <postgresql data directory> directory: > ls -ald <PostgreSQL data directory> 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 postgresql data directory is /var/lib/edb/as<version>/data (PGDATA), but this will vary according to local circumstances.

✔️ Fix
Run these commands: > chown enterprisedb <PostgreSQL data directory> > chgrp enterprisedb <PostgreSQL data directory> > chmod 700 <PostgreSQL data directory> The default path for the postgresql data directory is /var/lib/edb/as<version>/data (PGDATA), but this will vary according to local circumstances.