Assign Pre-installation Grants for Graph Schema

2.3.7 Assign Pre-installation Grants for Graph Schema

This section describes how to assign pre-installation grants for the Graph schema.

Note:

This section is applicable only for Graph use case.

Grant the following permissions to the newly created graph schema.

Pre-installation Grants for both BD and ECM Graphs

GRANT ANALYZE TO <GRAPH_SCHEMA>;
GRANT CREATE SESSION TO <GRAPH_SCHEMA>;
GRANT CREATE TABLE TO <GRAPH_SCHEMA>;
GRANT CREATE VIEW TO <GRAPH_SCHEMA>;
GRANT CREATE 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 TABLE TO <GRAPH_SCHEMA>;
GRANT SELECT ON SYS.V_$PARAMETER TO <GRAPH_SCHEMA>;
GRANT EXECUTE ON DBMS_ISCHED TO <GRAPH_SCHEMA>;
GRANT EXECUTE ON DBMS_PARALLEL_EXECUTE TO <GRAPH_SCHEMA>;
GRANT EXECUTE ON DBMS_STATS TO <GRAPH_SCHEMA>;
GRANT EXECUTE ON SYS.DBMS_LOCK TO <GRAPH_SCHEMA>;

Pre-installation Grants for BD Graph

Change the <BD_ATOMIC_SCHEMA> to the underlying schema of the data source of the BD graph pipeline.

Note:

The following grants are applicable for the Out-of-the-box graph pipeline only. 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.

GRANT SELECT ON <BD_ATOMIC_SCHEMA>.ACCT TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CUST_ACCT TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.ACCT_BAL_POSN_SMRY TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CUST TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.BACK_OFFICE_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.EMP TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CUST_CUST TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.KDD_CAL TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.KDD_REVIEW TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.EMP_ACCT TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.ACCT_SMRY_MNTH TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.ACCT_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.EXTERNAL_ENTITY TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CUST_EMAIL_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CUST_PHON TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CUST_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CASH_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.LINK_STAGE TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.WIRE_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.MI_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.INSTN_MASTER TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.EXTERNAL_ENTITY_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.DERIVED_ADDRESS TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.CLIENT_BANK TO <GRAPH_SCHEMA>;
GRANT SELECT ON <BD_ATOMIC_SCHEMA>.EXTERNAL_ENTITY_LINK TO <GRAPH_SCHEMA>;
GRANT ANALYZE TO <GRAPH_SCHEMA>;

Pre-installation Grants for ECM Graph

Change the <ECM_ATOMIC_SCHEMA> to the underlying schema of the data source of the ECM graph pipeline.

GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_ACCT TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CUST_ACCT TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_ACCT_BAL_POSN_SMRY TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CUST TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_BACK_OFFICE_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EMP TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CUST_CUST TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EMP_ACCT TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_ACCT_SMRY_MNTH TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_ACCT_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EXTERNAL_ENTITY TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CUST_EMAIL_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CUST_PHON TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CUST_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CASH_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_WIRE_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_MI_TRXN TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_INSTN_MASTER TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EXTERNAL_ENTITY_ADDR TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_DERIVED_ADDRESS TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CLIENT_BANK TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EXTERNAL_ENTITY_LINK TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.KDD_CASES TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.KDD_CASE_ACCOUNTS TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_SCENARIO_MASTER TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EVENTS TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EVENT_DETAILS TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_EVENT_ENTITY_MAP TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_PRECASE_CASE_MAP TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.KDD_CASE_CUSTOMERS TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.KDD_CASE_EXTERNAL_ENTITY TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.KDD_CASE_INSTN_MASTER TO <GRAPH_SCHEMA>;
GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CORRELATION_EVENT_MAP TO <GRAPH_SCHEMA>;
GRANT EXECUTE ON DBMS_SCHEDULER TO <ECM_ATOMIC_SCHEMA>;
GRANT EXECUTE ON DBMS_ISCHED TO <ECM_ATOMIC_SCHEMA>;
GRANT EXECUTE ON DBMS_PARALLEL_EXECUTE TO <ECM_ATOMIC_SCHEMA>;
GRANT CREATE JOB TO <ECM_ATOMIC_SCHEMA>;