6.0.2

Table 3‑2. Oracle Database Permissions for vCenter Server
Permission Description
GRANT CONNECT TO VPXADMIN Necessary for connecting to the Oracle database.
GRANT RESOURCE TO VPXADMIN Necessary for creating a trigger, sequence, type, procedure,
and so on.
By default, the RESOURCE role has the CREATE
PROCEDURE, CREATE TABLE, and CREATE SEQUENCE
privileges assigned. If the RESOURCE role lacks these
privileges, grant them to the vCenter Server database user.
GRANT CREATE VIEW TO VPXADMIN Necessary for creating a view.
GRANT CREATE SEQUENCE TO VPXADMIN Necessary for creating a sequence.
GRANT CREATE TABLE TO VPXADMIN Necessary for creating a table.
GRANT CREATE MATERIALIZED VIEW TO
VPXADMIN
Necessary for creating a materialized view.
GRANT EXECUTE ON dbms_lock TO VPXADMIN Necessary for guaranteeing that the vCenter Server
database is used by a single vCenter Server instance.
GRANT EXECUTE ON dbms_job TO VPXADMIN Necessary during installation or upgrade for scheduling
and managing the SQL jobs.
This permission is not required after deployment.
GRANT SELECT ON dba_lock TO VPXADMIN Necessary for determining existing locks on the
vCenter Server database.
GRANT SELECT ON dba_tablespaces TO VPXADMIN Necessary during upgrade for determining the required
disk space.
This permission is not required after deployment.
GRANT SELECT ON  TO VPXADMIN Necessary during upgrade for determining the required
disk space.
This permission is not required after deployment.
GRANT SELECT ON  TO VPXADMIN Necessary for monitoring the free space while
vCenter Server is working.
GRANT SELECT ON v_$session TO VPXADMIN View used to determine existing locks on the
vCenter Server database.
GRANT UNLIMITED TABLESPACE TO VPXADMIN Necessary for granting unlimited tablespace permissions to
the vCenter Server database user.
GRANT SELECT ON v_$system_event TO VPXADMIN Necessary for checking log le switches.
GRANT SELECT ON v_$sysmetric_history TO
VPXADMIN
Necessary for checking the CPU utilization.
GRANT SELECT ON v_$sysstat TO VPXADMIN Necessary for determining the Buer Cache Hit Ratio.
GRANT SELECT ON  TO VPXADMIN Necessary for determining the tablespace utilization.
GRANT SELECT ON v_$loghist TO VPXADMIN Necessary for checking the checkpoint frequency.
The privileges on the master database are used to monitor the vCenter Server database. so that, for example,
if a certain threshold is reached, you can see an alert.
Chapter 3 Before Upgrading vCenter Server
VMware, Inc. 61