Create the DTP Schema

It is mandatory to create the DTP Schema in order to use the DTP pipeline administration.

Assign the following grants to create the DTP schema:

CREATE USER <DTP_SCHEMA> IDENTIFIED BY <PASSWORD>;

GRANT CONNECT TO <DTP_SCHEMA>;

GRANT RESOURCE TO <DTP_SCHEMA>;

GRANT CREATE MATERIALIZED VIEW TO <DTP_SCHEMA>;

GRANT CREATE PROCEDURE TO <DTP_SCHEMA>;

GRANT CREATE SEQUENCE TO <DTP_SCHEMA>;

GRANT CREATE SESSION TO <DTP_SCHEMA>;

GRANT CREATE SYNONYM TO <DTP_SCHEMA>;

GRANT CREATE TABLE TO <DTP_SCHEMA>;

GRANT CREATE TRIGGER TO <DTP_SCHEMA>;

GRANT CREATE VIEW TO <DTP_SCHEMA>;

GRANT UNLIMITED TABLESPACE TO <DTP_SCHEMA>;

GRANT EXECUTE ON SYS.DBMS_CRYPTO TO <DTP_SCHEMA>;

GRANT EXECUTE ON SYS.DBMS_JAVA TO <DTP_SCHEMA>;

GRANT EXECUTE ON SYS.DBMS_UTILITY TO <DTP_SCHEMA>;