Unable to view licenses on vCenter due to error "To view and manage licenses, you must have the Global.Licenses privilege"

Products

• VMware vCenter Server 7.0
• VMware vCenter Server 8.0
• VMware vCenter Server 6.0

Issue/Introduction

Environment

VMware vCenter Server 7.0.x

VMware vCenter Server 8.0.x

Cause

Role_ID value is changed for administrator in VCDB 

Resolution

1.Take a snapshot / backup of the vCenter.(Take Offline snapshots if vCenter servers are connected in linked mode)

2. Connect to vCenter database (VCDB)

• /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres

3. Run the command, 

• select * from vpx_access;

4. Changed the role ID to default value  -1 

• update vpx_access set role_id = -1 where role_id = 10;

5. Restart vpxd service on the vCenter 

• service-control --restart vpxd