Go to primary content

Oracle Product Lifecycle Analytics Installation and Setup Guide Release 3.6.1 E83715-03 |
| Contents

Previous | Next |

# 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.
CREATE DATABASE LINK | Create DBLink to Agile PLM source database for every ETL run.
CREATE SYNONYM* | Create a synonym for the source table.
CREATE JOB | Creates a job in 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