Go to primary content

Oracle Product Lifecycle Analytics Security Guide Release 3.6 E83718-01 |
| Contents

Previous | Next |

# 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 |