9 DB Privileges

The DB privileges vary for single schema and multiple schema installations.

9.1 Single Database Schema Privileges

The following are the privileges required when you use a single schema to host the DataMart, ODI Master, and ODI Work Repository objects:

Privilege	Purpose
CONNECT,RESOURCE	Basic privilege for the Schema User.
CREATE DATABASE LINK	Create DBLink to Agile PLM source system for every ETL run.
CREATE JOB	Creates a job in the schema
CREATE TABLE	Create table privilege for the schema.
CREATE SYNONYM*	Create a synonym for the source table.
CREATE MATERIALIZED VIEW*	Create materialized view on the schema.
SELECT ON V_$DATABASE	Read platform information.
ALL ON SYS.DBMS_PIPE	PL/SQL logger privileges
EXECUTE ON, SYS.DBMS_SYSTEM
CREATE VIEW	Create a view on the schema.
*Denotes Agile PLM databases only

9.2 Privileges for Multiple Schemas

The following are the privileges required when you install the Data Mart (ODM and MDS) on one schema and the ODI Master and ODI Work repositories on a separate schema:

Privilege	Purpose
CONNECT, RESOURCE	Required for MDS and ODI Repository schemas
CREATE SYNONYM	Create a synonym for the source table.
CREATE DATABASE LINK	Create DBLink to Agile PLM source database for every ETL run.
CREATE JOB	Creates a job in the schema
CREATE MATERIALIZED VIEW	Create materialized view on the schema.
CREATE VIEW	Create a view privilege for the schema.
CREATE TABLE	Create table privilege for the schema.
SELECT ON V_$DATABASE	Reads Platform information.
ALL ON SYS.DBMS_PIPE	PL/SQL Logger Privileges
EXECUTE ON SYS.DMBS_SYSTEM

The following are the privileges required when you install ODM and MDS in different schemas:

Privilege	Purpose
CONNECT, RESOURCE	Basic privilege for schema user
CREATE MATERIALIZED VIEW	Create a materialized view on the schema.