VMware VCENTER CHARGEBACK 1.5 - API Bedienungsanleitung PDF herunterladen (Seite 17)

You must provide the details of the database and database user when installing vCenter Chargeback

Manager. The installer uses these details to create the database schema and objects. Also, vCenter

Chargeback Manager and the data collector authenticates in to the database by using this database user

account to perform the necessary database operations.

NOTE Instead of using the default database users, such as sa, SYS, and SYSTEM, create a database user with

just the required privileges and access the database with this users credentials. This is a good security

practice.

vCenter Chargeback Manager Database User Privileges in Oracle Database

After you create a database instance and a database user in Oracle Database that vCenter Chargeback

Manager can use, you must assign the following system roles and privileges to this user.

CONNECT

RESOURCE

CREATE TRIGGER

CREATE TABLE

CREATE VIEW

CREATE PROCEDURE

CREATE SEQUENCE

DROP TABLE

This privilege is required when upgrading vCenter Chargeback Manager.

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;

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.

Chapter 3 Install and Upgrade Prerequisites

VMware, Inc. 17

1 2 ... 12 13 14 15 16 17 18 19 20 21 22 ... 59 60

Keine Kommentare

VMware VCENTER CHARGEBACK 1.5 - API Bedienungsanleitung Seite 17