← Back to EDB Postgres Advanced Server v9.6 Security Technical Implementation Guide

V-213607

CAT II (Medium)

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

Rule ID

SV-213607r879649_rule

STIG

EDB Postgres Advanced Server v9.6 Security Technical Implementation Guide

Version

V2R3

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 <postgressql 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/ppas/9.5/data, but this will vary according to local circumstances.)

Fix Text

Run these commands:

1) "chown enterprisedb <postgresql data directory>" 

2) "chgrp enterprisedb <postgresql data directory>" 

3) "chmod 700 <postgresql data directory>"

(The default path for the postgresql data directory is /var/lib/ppas/9.5/data, but this will vary according to local circumstances.)