VCPG-67-000017 - VMware Postgres must not allow schema access to unauthorized accounts.

Information

Database management systems typically separate security functionality from non-security functionality via separate databases or schemas. Database objects or code implementing security functionality should not be commingled with objects or code implementing application logic. When security and non-security functionality are commingled, users who have access to non-security functionality may be able to access security functionality.

VMware Postgres contains a number of system configuration schema whose access must be strictly limited. By default, the pg_catalog and information_schema objects are configured to only be accessible in a read-only manner publicly, and otherwise only accessible by the Postgres user. This configuration must be verified and maintained.

Solution

At the command prompt, execute the following command:

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

Replace <name> and <user> with the Access Privilege name and account, respectively, discovered during the check.

Item Details

Audit Name: DISA STIG VMware vSphere 6.7 PostgreSQL v1r2

Category: SYSTEM AND COMMUNICATIONS PROTECTION

Plugin: Unix

Control ID: 98ff568beb7eb1c8bf4521092c18f6ed3774e9f9699b28067996b160fe7d288d

Detections

Analytics

VCPG-67-000017 - VMware Postgres must not allow schema access to unauthorized accounts.

Information

Solution

See Also

Item Details