2.5

vCenter Chargeback Manager Database User Privileges in SQL Server
After you create a database instance and a database user in SQL Server that vCenter Chargeback Manager can
use, you must assign privileges to this user by running the following commands in SQL Server:
CREATE ROLE CB_ADMIN_ROLE;
GRANT ALTER ON SCHEMA :: DBO TO CB_ADMIN_ROLE;
GRANT REFERENCES ON SCHEMA :: DBO TO CB_ADMIN_ROLE;
GRANT INSERT ON SCHEMA :: DBO TO CB_ADMIN_ROLE;
GRANT SELECT ON SCHEMA :: DBO TO CB_ADMIN_ROLE;
GRANT DELETE ON SCHEMA :: DBO TO CB_ADMIN_ROLE;
GRANT UPDATE ON SCHEMA :: DBO TO CB_ADMIN_ROLE;
GRANT EXECUTE ON SCHEMA :: DBO TO CB_ADMIN_ROLE;
GRANT ALTER ANY DATASPACE TO CB_ADMIN_ROLE;
GRANT CREATE TABLE to CB_ADMIN_ROLE;
GRANT CREATE VIEW to CB_ADMIN_ROLE;
GRANT CREATE PROCEDURE to CB_ADMIN_ROLE;
GRANT CREATE FUNCTION TO CB_ADMIN_ROLE;
GO
sp_addrolemember CB_ADMIN_ROLE, <db_username>
The commands provided assume that DBO is the default schema for the database user. Ensure the you provide
the ALTER ANY DATASPACE privilege. This is privilege is required to run the database partitioning scripts
during upgrade.
Maximum Number of Connections to the Database
The vCenter Chargeback Manager and corresponding data collectors, including the vCloud Director data
collector and vShield Manager data collector, connect to the vCenter Chargeback Manager database to read
and write data. You must configure the database to ensure that the maximum number of connections can be
made to the vCenter Chargeback Manager database by each of the components.
Table 3-1 lists the maximum number of connections made to the vCenter Chargeback Manager database by a
single instance of vCenter Chargeback Manager, vCenter Chargeback Manager data collector, vCloud Director
data collector, and vShield Manager data collector. The table also lists the maximum connections made to the
vCenter Server database by a single instance of the vCenter Chargeback Manager data collector.
Table 3-1. Maximum Number of Database Connections
Component Database Maximum Connections
vCenter Chargeback Manager server vCenter Chargeback Manager
database
50
vCenter Chargeback Manager data
collector
vCenter Chargeback Manager
database
35
vCloud Director data collector vCenter Chargeback Manager
database
10
Although a single connection is made,
the connection pool requires 10
connections
Chapter 3 Install and Upgrade Prerequisites
VMware, Inc. 17