B Database Schema Privileges

In Oracle Product Lifecycle Analytics (OPLA), database privileges vary for single schema and multiple schema installations.

B.1 Single Database Schema Privileges

This table lists and explains the privileges required to use a single schema to host the DataMart, ODI Master, and the ODI Work Repository objects in Oracle Product Lifecycle Analytics (OPLA).

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	Create 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
CREATEVIEW	Create a View on the Schema
* Agile PLM databases only

B.2 OPLA Multiple Schema Privileges

This table lists and explains the privileges required when you install the 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 DATABASE LINK	Create DBLink to Agile PLM source database for every ETL run.
CREATE SYNONYM	Create a synonym for the source table in the ODI Work Repository schema
CREATE TABLE	Create i$, e$, c$ tables in the ODI Work Repository schema.
CREATE VIEW	Create a view privilege for the schema.
CREATE MATERIALIZED VIEW	Create a materialized view on the schema.
CREATE JOB	Create a job in the schema
SELECT ON V_$DATABASE	Reads Platform information.
ALL ON SYS.DBMS_PIPE
EXECUTE ON SYS.DMBS_SYSTEM

This table lists and explains the privileges required when you install ODM and MDS in different schemas.

Privilege	Purpose
CONNECT, RESOURCE	Basic privilege for schema user
CREATE SYNONYM	Create a synonym for the source table in the ODI Work Repository schema
CREATE DATABASE LINK	Create DBLink to Agile PLM source database for every ETL run.
CREATE MATERIALIZED VIEW	Create a materialized view on the schema.
CREATE VIEW	Create a view privilege for the schema.
CREATE TABLE	Create i$, e$, c$ tables in the ODI Work Repository schema
CREATE JOB	Create a job in the schema
SELECT ON V_$DATABASE	Reads Platform information.
ALL ON SYS.DBMS_PIPE
EXECUTE ON SYS.DMBS_SYSTEM