2.3.3 Assign Grants for Studio Schema

This section describes how to assign grants for Studio schema.

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

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

Note:

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

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