6.5.1

5 Make a full backup of the vCenter Server database.
Your database is prepared for the vCenter Server upgrade.
Database Permission Requirements for vCenter Server
vCenter Server requires a database. If you decide to use an external Oracle or Microsoft SQL Server
database, when you create the database, you must grant certain permissions to the database user.
When upgrading a Microsoft SQL database, the permissions must be set correctly.
Table 3‑6. Microsoft SQL Database Permissions for vCenter Server
Permission Description
GRANT ALTER ON SCHEMA :: [VMW] TO VC_ADMIN_ROLE Mandatory when you work with SQL Server custom schema.
GRANT REFERENCES ON SCHEMA :: [VMW] TO
VC_ADMIN_ROLE
Mandatory when you work with SQL Server custom schema.
GRANT INSERT ON SCHEMA :: [VMW] TO
VC_ADMIN_ROLE
Mandatory when you work with SQL Server custom schema.
GRANT CREATE TABLE TO VC_ADMIN_ROLE Necessary for creating a table.
GRANT CREATE VIEW TO VC_ADMIN_ROLE Necessary for creating a view.
GRANT CREATE PROCEDURE TO VC_ADMIN_ROLE Necessary for creating a stored procedure.
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
vSphere Upgrade
VMware, Inc. 134