2.8.3.2 Assign Grants for ER Schema

This section describes how to assign Grants for ER schema.

Grant the following permissions to the newly created Oracle Database ER schema:

GRANT CREATE SESSION TO <ER SCHEMA USER>;
GRANT CREATE TABLE TO <ER SCHEMA USER>;
GRANT CREATE VIEW TO <ER SCHEMA USER>;
GRANT CREATE TRIGGER TO <ER SCHEMA USER>;
GRANT CREATE PROCEDURE TO <ER SCHEMA USER>;
GRANT CREATE SEQUENCE TO <ER SCHEMA USER>;
GRANT EXECUTE ON DBMS_RLS TO <ER SCHEMA USER>;
GRANT EXECUTE ON SYS.DBMS_SESSION TO <ER SCHEMA USER>;
GRANT CREATE SYNONYM TO <ER SCHEMA USER>;
GRANT EXECUTE ON DBMS_REDEFINITION TO <ER SCHEMA USER>;
GRANT REDEFINE TABLE TO <ER SCHEMA USER>;
GRANT CREATE MATERIALIZED VIEW TO <ER SCHEMA USER>;
GRANT SELECT ON SYS.V_$PARAMETER TO <ER SCHEMA USER>;
GRANT SELECT ON SYS.DBA_FREE_SPACE TO <ER SCHEMA USER>;
GRANT SELECT ON SYS.DBA_TABLES TO <ER SCHEMA USER>;
GRANT SELECT ON SYS.DBA_TAB_COLUMNS TO <ER SCHEMA USER>;
GRANT CREATE RULE TO <ER SCHEMA USER>;
GRANT DROP TRIGGER TO <ER SCHEMA USER>;
GRANT SELECT ON SYS.DBA_RECYCLEBIN TO <ER SCHEMA USER>;
GRANT CREATE JOB TO <ER SCHEMA USER>;
GRANT EXECUTE ON DBMS_LOCK TO <ER SCHEMA USER>;
GRANT EXECUTE ON DBMS_STATS TO <ER SCHEMA USER>;
GRANT ANALYZE TO <ER SCHEMA USER>;
GRANT CREATE TYPE TO <ER SCHEMA USER>;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO <ER SCHEMA USER>;

Note:

The following grants are applicable when MATCHING_MECHANISM is set to OT in the config.sh file.

GRANT EXECUTE ON CTXSYS.CTX_THES TO <ER SCHEMA USER>;
GRANT MANAGE SCHEDULER TO <ER SCHEMA USER>;
GRANT EXECUTE ON DBMS_MVIEW TO <ER SCHEMA USER>;

Note:

The following grants should be revoked after the successful installation of Compliance Studio.

REVOKE SELECT ON SYS.DBA_RECYCLEBIN FROM <ER SCHEMA USER>;
REVOKE SELECT ON SYS.DBA_FREE_SPACE FROM <ER SCHEMA USER>;
REVOKE SELECT ON SYS.DBA_TABLES FROM <ER SCHEMA USER>;
REVOKE SELECT ON SYS.DBA_TAB_COLUMNS FROM <ER SCHEMA USER>;