← Back to EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide

V-259262

CAT II (Medium)

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

Rule ID

SV-259262r961149_rule

STIG

EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide

Version

V2R1

CCIs

CCI-001090

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.