Title

Access to database files must be limited to relevant processes and to authorized, administrative users. (Cat II impact)

Discussion

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 Content

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 Text

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.

Additional Identifiers

Rule ID: SV-259262r938839_rule

Vulnerability ID: V-259262

Group Title: SRG-APP-000243-DB-000374

Expert Comments

CCIs tied to check.

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