SV-239202r717054_rule
V-239202
SRG-APP-000133-DB-000362
VCPG-67-000009
CAT II
10
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.
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.
V-239202
False
VCPG-67-000009
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.
M
5324