4.2.4 Create the Graph Schema

You must create an Oracle User to create the Graph Schema. For more details, see 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 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> to the schema used in the Graph pipeline.

Note:

If the user has to execute the custom graph, the same permissions have to be provided for the input tables referred in Custom Graph Pipeline.