4.2.2 Creating the Application Configuration Schema

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. This section discusses the various grants required for the Oracle Database User.

Assign the Grants

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>;

create or replace DIRECTORY fs_list_logs_dir AS '/file_store/fs_list/logs/';

grant read, write on DIRECTORY fs_list_logs_dir TO schema_name;

create or replace DIRECTORY fs_list_script_dir AS '/file_store/fs_list/script/';

grant read, execute on DIRECTORY fs_list_script_dir TO schema_name;

create or replace DIRECTORY fs_list_control_dir AS '/file_store/fs_list/control/';

grant read on DIRECTORY fs_list_control_dir TO schema_name;

Note:

This is required for the configuration schema and the workspace schema.