SV-256596r918971_rule
V-256596
SRG-APP-000133-DB-000200
VCPG-70-000006
CAT II
10
At the command prompt, run the following command:
# /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres -c "ALTER TABLE <tablename> OWNER TO vc;"
Replace <tablename> with the name of the table discovered during the check.
At the command prompt, run the following command:
# /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres -t -A -c "\dt;" | grep -v 'table|vc'
If any tables are returned, this is a finding.
Note: Upgrades may introduce new tables that are owned by the "postgres" user and can be updated to be owned by the "vc" user.
V-256596
False
VCPG-70-000006
At the command prompt, run the following command:
# /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres -t -A -c "\dt;" | grep -v 'table|vc'
If any tables are returned, this is a finding.
Note: Upgrades may introduce new tables that are owned by the "postgres" user and can be updated to be owned by the "vc" user.
M
5521