STIGQter STIGQter: STIG Summary: VMware vSphere 6.7 PostgreSQL Security Technical Implementation Guide Version: 1 Release: 1 Benchmark Date: 09 Mar 2021:

VMware Postgres must limit modify privileges to authorized accounts.

DISA Rule

SV-239202r717054_rule

Vulnerability Number

V-239202

Group Title

SRG-APP-000133-DB-000362

Rule Version

VCPG-67-000009

Severity

CAT II

CCI(s)

Weight

10

Fix Recommendation

At the command prompt, execute the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "REVOKE ALL PRIVILEGES FROM <user>;"

Replace <user> with the account discovered during the check.

Check Contents

At the command prompt, execute the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "\du;"|grep "Create"

Expected result:

postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
vc | Create DB | {}

If the accounts other than "postgres" and "vc" have any "Create" privileges, this is a finding.

Vulnerability Number

V-239202

Documentable

False

Rule Version

VCPG-67-000009

Severity Override Guidance

At the command prompt, execute the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "\du;"|grep "Create"

Expected result:

postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
vc | Create DB | {}

If the accounts other than "postgres" and "vc" have any "Create" privileges, this is a finding.

Check Content Reference

M

Target Key

5324

Comments