To use Oracle Data Integrator (ODI) with Primavera Unifier, grant the required rights to the Primavera Unifier user (for example, UNIFIER).
Complete the following steps:
- Sign in to a Primavera Unifier instance (with SQL Plus, SQL Developer, and so on) as SYSDBA.
- Use the following statements to grant additional rights to the Primavera Unifier user:
GRANT ADMINISTER DATABASE TRIGGER, CREATE ANY TRIGGER, CREATE DATABASE LINK, SELECT ANY SEQUENCE, CREATE ANY SYNONYM, DROP ANY INDEX, ALTER ANY INDEX, CREATE ANY INDEX, DELETE ANY TABLE, UPDATE ANY TABLE, INSERT ANY TABLE, SELECT ANY TABLE, COMMENT ANY TABLE, DROP ANY TABLE, ALTER ANY TABLE, CREATE ANY TABLE, UNLIMITED TABLESPACE, DROP ANY VIEW, CREATE ANY VIEW, ANALYZE ANY, CONNECT, RESOURCE TO UNIFIER;
GRANT SELECT ON SYS.V_$PARAMETER TO UNIFIER;
GRANT SELECT ON SYS.GV_$SESSION TO UNIFIER;
GRANT SELECT ON SYS.GV_$TRANSACTION TO UNIFIER;
GRANT SELECT ON SYS.GV_$LOCK TO UNIFIER;