Installation

Table Of Contents
2 Run the following SQL command to create a View Composer database user with the correct
permissions.
CREATE USER "VCMPADMIN" PROFILE "DEFAULT" IDENTIFIED BY "oracle" DEFAULT TABLESPACE
"VCMP" ACCOUNT UNLOCK;
grant connect to VCMPADMIN;
grant resource to VCMPADMIN;
grant create view to VCMPADMIN;
grant create sequence to VCMPADMIN;
grant create table to VCMPADMIN;
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 12c or 11g
After you add a View Composer database to an Oracle 12c or 11g instance, you must configure an ODBC
connection to the new database to make this data source visible to the View Composer service.
When you configure an ODBC DSN for View Composer, secure the underlying database connection to an
appropriate level for your environment. For information about securing database connections, see the
Oracle database documentation.
If the underlying database connection uses SSL encryption, we recommend that you configure your
database servers with SSL certificates signed by a trusted CA. If you use self-signed certificates, your
database connections might be susceptible to man-in-the-middle attacks.
Prerequisites
Verify that you completed the steps described in Add a View Composer Database to Oracle 12c or 11g or
Use a SQL Statement to Add a View Composer Database to an Oracle Instance.
Procedure
1 On the View Composer database 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.
View Installation
VMware, Inc. 48