VMware vSphere 7.0 vCenter Appliance PostgreSQL STIG Version Comparison

There are 1 differences between versions v1 r1 (March 7, 2023) (the "left" version) and v1 r2 (July 26, 2023) (the "right" version).

Check VCPG-70-000006 was changed between these two versions. Green, underlined text was added, red, struck-out text was removed.

The regular view of the left check and right check may be easier to read.

Title

All vCenter database (VCDB) tables must be owned by the "vc" user account.

Check Content

At the command prompt, run the following command: # /opt/vmware/vpostgres/current/bin/psql -d VCDB -x -U postgres -t -A -c "\dt;"|grep Owner|grep "\dt;" | grep -v vc If 'table|vc' If any tables are returned, this is a finding. 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.

Discussion

Within the database, object ownership implies full privileges to the owned object, including the privilege to assign access to the owned objects to other subjects. Database functions and procedures can be coded using definer's rights. This allows anyone who uses the object to perform the actions if they are the owner. If not properly managed, this can lead to privileged actions being taken by unauthorized individuals. VCDB is configured out of the box to be owned by the "vc" Postgres user. This configuration must be verified and maintained.

Fix

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.