4.2.2 Create the MMG Application Schema

You must create an Oracle User to create the MMG Application Schema. For more details, see Creating an Oracle User section.

Assign the Grants

This section discusses the various grants required for the Oracle Database User.

Assign the following grants:

grant create SESSION to <oracle_database_user>;

grant create PROCEDURE to <oracle_database_user>;

grant create SEQUENCE to <oracle_database_user>;

grant create TABLE to <oracle_database_user>;

grant create TRIGGER to <oracle_database_user>;

grant create VIEW to <oracle_database_user>;

grant create MATERIALIZED VIEW to <oracle_database_user>;

grant select on SYS.V_$PARAMETER to <oracle_database_user>;

grant create SYNONYM to <oracle_database_user>;

grant select on sys.v_$parameter to <oracle_database_user>;

grant select on sys.dba_free_space to <oracle_database_user>;

grant select on sys.dba_tables to <oracle_database_user>;

grant select on sys.Dba_tab_columns to <oracle_database_user>;

grant create RULE to <oracle_database_user>;

grant create any trigger to <oracle_database_user>;

grant drop any trigger to <oracle_database_user>;

grant select on SYS.DBA_RECYCLEBIN to <oracle_database_user>;

Note:

This is required for MMG Config Schema and the Workspace Schemas.