6.5.1

GRANT SELECT ON msdb.dbo.sysjobs to VC_ADMIN_ROLE
go
GRANT SELECT ON msdb.dbo.sysjobs_view to VC_ADMIN_ROLE
go
GRANT EXECUTE ON msdb.dbo.sp_add_job TO VC_ADMIN_ROLE
go
GRANT EXECUTE ON msdb.dbo.sp_delete_job TO VC_ADMIN_ROLE
go
GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO VC_ADMIN_ROLE
go
GRANT EXECUTE ON msdb.dbo.sp_update_job TO VC_ADMIN_ROLE
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 vCenter Server
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 confirmed 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/vpostgres/9.4/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.
vSphere Upgrade
VMware, Inc. 133