Create MMG Graph Schema

Ensure that you create an oracle user before creating the MMG Graph Schema. For more details, see the Creating an Oracle User section.

Assign Grants

This section discusses the various grants required for the graph schemas.

Assign the following grants for the schema:

1. Pre-installation grants for the graph schema:

GRANT CREATE SESSION TO <GRAPH_SCHEMA>;

GRANT CREATE TABLE TO <GRAPH_SCHEMA>;

GRANT CREATE VIEW TO <GRAPH_SCHEMA>;

GRANT CREATE ANY PROCEDURE TO <GRAPH_SCHEMA>;

GRANT CREATE SEQUENCE TO <GRAPH_SCHEMA>;

GRANT CREATE JOB TO <GRAPH_SCHEMA>;

GRANT CREATE MATERIALIZED VIEW TO <GRAPH_SCHEMA>;

GRANT EXECUTE ON DBMS_SCHEDULER to <GRAPH_SCHEMA>;

GRANT EXECUTE ON DBMS_COMPARISON TO <GRAPH_SCHEMA>;

GRANT EXECUTE ON DBMS_RLS TO <GRAPH_SCHEMA>;

GRANT EXECUTE ON SYS.DBMS_SESSION TO <GRAPH_SCHEMA>;

GRANT EXECUTE ON DBMS_REDEFINITION TO <GRAPH_SCHEMA>;

GRANT REDEFINE ANY TABLE TO <GRAPH_SCHEMA>;

GRANT SELECT ON SYS.V_$PARAMETER TO <GRAPH_SCHEMA>;

GRANT SELECT ON <DATA_SOURCE_SCHEMA>.<TABLE_NAME> TO <GRAPH_SCHEMA>;

Example:

Change the <DATA_SOURCE_SCHEMA> for the schema that is used in the graph pipeline.

Note:

If a user has to execute the custom graph, the same permissions have to be provided for the input tables that are referred to in the custom graph pipeline.