6.7

Table 3‑6. Microsoft SQL Database Permissions for vCenter Server (Continued)
Permission Description
GRANT SELECT ON SCHEMA :: [VMW] TO VC_USER_ROLE Permissions that let you run SELECT, INSERT, DELETE,
UPDATE operations on tables which are part of the VMW
schema.
GRANT INSERT ON SCHEMA :: [VMW] TO VC_USER_ROLE
GRANT DELETE ON SCHEMA :: [VMW] TO VC_USER_ROLE
GRANT UPDATE ON SCHEMA :: [VMW] TO VC_USER_ROLE
GRANT EXECUTE ON SCHEMA :: [VMW] TO
VC_USER_ROLE
Necessary for running a stored procedure in the db schema.
GRANT SELECT ON msdb.dbo.syscategories TO
VC_ADMIN_ROLE
Necessary for deploying SQL Server jobs.
These permissions are mandatory only during installation and
upgrade and not required after deployment.
GRANT SELECT ON msdb.dbo.sysjobsteps
TOVC_ADMIN_ROLE
GRANT SELECT ON msdb.dbo.sysjobs TO
VC_ADMIN_ROLE
GRANT EXECUTE ON msdb.dbo.sp_add_job TO
VC_ADMIN_ROLE
GRANT EXECUTE ON msdb.dbo.sp_delete_job TO
VC_ADMIN_ROLE
GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO
VC_ADMIN_ROLE
GRANT EXECUTE ON msdb.dbo.sp_update_job TO
VC_ADMIN_ROLE
GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO
VC_ADMIN_ROLE
GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO
VC_ADMIN_ROLE
GRANT EXECUTE ON msdb.dbo.sp_add_category TO
VC_ADMIN_ROLE
GRANT VIEW SERVER STATE TO [vpxuser] Provides access to SQL Server DMV views and sp_lock
execution.
GRANT VIEW ANY DEFINITION TO [vpxuser] Necessary for providing the user with the privileges to see
metadata for SQL Server objects.
Table 3‑7. 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.
vCenter Server Installation and Setup
VMware, Inc. 107