6.5.1

use MSDB
go
CREATE USER vpxuser for LOGIN vpxuser
go
You now have a Microsoft SQL Server database that you can use with vCenter Server.
2 Assign the db_owner role to the vCenter Server database user on both the vCenter Server and msdb
databases.
For example, to assign the db_owner role to the vpxuser user, you can run the following script:
use VCDB
go
sp_addrolemember @rolename = 'db_owner', @membername = 'vpxuser'
go
use MSDB
go
sp_addrolemember @rolename = 'db_owner', @membername = 'vpxuser'
go
3 Enable database monitoring for the vCenter Server database user.
For example, to grant database disk size monitoring permissions to the vpxuser user, you can run the
following script:
use master
go
grant VIEW SERVER STATE to vpxuser
go
GRANT VIEW ANY DEFINITION TO vpxuser
go
When you install vCenter Server, the installer uses the default dbo schema to assign permissions to the
db_owner role.
Prepare the vCenter Server Database by Creating Custom Database Schema and Roles
As an alternative to using the db_owner database role, experienced database administrators can set
permissions by creating database schema and roles manually, which ensures greater control over
database permissions.
You must first create a database and user for vCenter Server. Then you can create a custom schema and
new database roles for the database user. You must also enable database monitoring for the user before
you install vCenter Server. See Database Permission Requirements for vCenter Server.
To perform the following procedure, you can either use the graphical user interface or run scripts. The
vCenter Server installer package contains example scripts in the vCenter-
Server\dbschema\DB_and_schema_creation_scripts_PostgreSQL.txt file.
vSphere Installation and Setup
VMware, Inc. 289