6.0.2

go
GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO VC_ADMIN_ROLE
go
GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO VC_ADMIN_ROLE
go
GRANT EXECUTE ON msdb.dbo.sp_add_category TO VC_ADMIN_ROLE
go
sp_addrolemember VC_ADMIN_ROLE , [vpxuser]
go
use master
go
grant VIEW SERVER STATE to [vpxuser]
go
GRANT VIEW ANY DEFINITION TO [vpxuser]
go
Prepare PostgreSQL Database Before Upgrading to vCenter Server 6.0
Ensure that your PostgreSQL database meets requirements, that you have the necessary credentials, and that
you complete any necessary cleanup or other preparation before upgrading vCenter Server.
For information about backing up the vCenter Server database, see the PostgreSQL documentation.
Prerequisites
Verify that you have conrmed basic upgrade interoperability before preparing your PostgreSQL database
for upgrading vCenter Server.
Procedure
1 Verify that passwords are current and not set to expire soon.
2 Locate the cleanup_orphaned_data_PostgresSQL.sql script in the ISO image and copy it to your
PostgreSQL server.
3 Log in to vCenter Server Appliance as root user.
4 Run the cleanup script.
/opt/vmware/PostgreSQL/1.0/bin/psql -U postgres -d VCDB -f pathcleanup_orphaned_data_Postgres.sql
The cleanup script cleans and purges any unnecessary or orphaned data in your vCenter Server
database that is not used by any vCenter Server component.
5 Make a full backup of the vCenter Server database and the vCenter Inventory Service 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.
Chapter 3 Before Upgrading vCenter Server
VMware, Inc. 59