STIGQter: STIG Summary: VMware vSphere 7.0 vCenter Appliance PostgreSQL Security Technical Implementation Guide Version: 1 Release: 2 Benchmark Date: 26 Jul 2023:

VMware Postgres must limit modify privileges to authorized accounts.

DISA Rule

SV-256597r887577_rule

Vulnerability Number

V-256597

Group Title

SRG-APP-000133-DB-000362

Rule Version

VCPG-70-000007

Severity

CAT II

CCI(s)

• CCI-001499 - Limit privileges to change software resident within software libraries.

Weight

10

Fix Recommendation

At the command prompt, run 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, run 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 | {}
vlcmuser | Create DB | {}

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

Vulnerability Number

V-256597

Documentable

False

Rule Version

VCPG-70-000007

Severity Override Guidance

At the command prompt, run 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 | {}
vlcmuser | Create DB | {}

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

Check Content Reference

M

Target Key

5521