To use Oracle Data Integrator (ODI) with P6 EPPM, grant the required rights to the P6 EPPM Extended Schema user. For example, PXRPTUSER.
Complete the following steps:
- Sign in to the P6 EPPM instance as SYSDBA.
- Use the following statements to grant additional rights to the P6 EPPM Extended Schema 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 PXRPTUSER;
GRANT SELECT ON SYS.V_$PARAMETER TO PXRPTUSER;
GRANT SELECT ON SYS.GV_$SESSION TO PXRPTUSER;
GRANT SELECT ON SYS.GV_$TRANSACTION TO PXRPTUSER;
GRANT SELECT ON SYS.GV_$LOCK TO PXRPTUSER;