5.0

Table Of Contents
grant create materialized view to VCMPADMIN;
grant execute on dbms_lock to VCMPADMIN;
grant execute on dbms_job to VCMPADMIN;
grant unlimited tablespace to VCMPADMIN;
In this example, the user name is VCMPADMIN and the View Composer database name is VCMP.
By default the resource role has the create procedure, create table, and create sequence privileges
assigned. If the resource role does not have these privileges, explicitly grant them to the View Composer
database user.
Add an ODBC Data Source to Oracle 11g or 10g
After you add a View Composer database to an Oracle 11g or 10g instance, you must configure an ODBC
connection to the new database to make this data source visible to the View Composer service.
These instructions assume that you are configuring the ODBC data source on Windows Server 2003 SP2.
Prerequisites
Verify that you completed the steps described in “Add a View Composer Database to Oracle 11g or 10g,” on
page 30 or “Use a SQL Statement to Add a View Composer Database to an Oracle Instance,” on page 31.
Procedure
1 On the vCenter Server computer, select Start > Administrative Tools > Data Source (ODBC).
2 From the Microsoft ODBC Data Source Administrator wizard, select the System DSN tab.
3 Click Add and select the appropriate Oracle driver from the list.
For example: OraDb11g_home
4 Click Finish.
5 In the Oracle ODBC Driver Configuration dialog box, type a DSN to use with View Composer, a
description of the data source, and a user ID to connect to the database.
If you configured an Oracle database user ID with specific security permissions, specify this user ID.
NOTE You use the DSN when you install the View Composer service.
6 Specify a TNS Service Name by selecting the Global Database Name from the drop-down menu.
The Oracle Database Configuration Assistant specifies the Global Database Name.
7 To verify the data source, click Test Connection and click OK.
What to do next
Install the new View Composer service on the vCenter Server computer. See “Install the View Composer
Service,” on page 32.
Install the View Composer Service
To use View Composer, you must install the View Composer service on the vCenter Server computer. View
Manager uses View Composer to create and deploy linked-clone desktops in vCenter Server.
You install the View Composer service on the Windows Server computer on which vCenter Server is installed.
Prerequisites
n
Verify that your installation satisfies the View Composer requirements described in “View Composer
Requirements,” on page 9.
VMware View Installation
32 VMware, Inc.