2.8.4.2 Assign Post-installation Grants for Graph Schema

This section describes how to assign the post-installation Grants for Graph schema.

Grant the following permissions to the newly created Graph schema.

• Post-installation Grants for BD Graph

  GRANT EXECUTE ON <BD_ATOMIC_SCHEMA>.P_FCC_CS_BD_EXTERNAL_ENTITY TO
  <GRAPH_SCHEMA>;
  GRANT SELECT ON <BD_ATOMIC_SCHEMA>.FCC_CS_BD_EXTERNAL_ENTITY TO
  <GRAPH_SCHEMA>;
  GRANT SELECT ON <BD_ATOMIC_SCHEMA>.FCC_CS_BD_DERIVED_GROUP TO
  <GRAPH_SCHEMA>;

• Post-installation Grants for ECM Graph

  GRANT EXECUTE ON <ECM_ATOMIC_SCHEMA>.P_FCC_CS_CM_EXTERNAL_ENTITY TO
  <GRAPH_SCHEMA>;
  GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CS_CM_EXTERNAL_ENTITY TO
  <GRAPH_SCHEMA>;
  GRANT SELECT ON <ECM_ATOMIC_SCHEMA>.FCC_CS_CM_DERIVED_GROUP TO
  <GRAPH_SCHEMA>;
  GRANT DELETE ON <ECM_ATOMIC_SCHEMA>.FCC_GRAPH_M_TRXN_VIEWS TO
  <GRAPH_SCHEMA>;

• Post-installation Grants for both BD and ECM Graphs

  GRANT SELECT, INSERT, UPDATE, DELETE ON
  <STUDIO_SCHEMA>.FCC_GRAPH_M_TRXN_VIEWS TO <GRAPH_SCHEMA>;
  GRANT SELECT ON <STUDIO_SCHEMA>.FCC_M_TABLES TO <GRAPH_SCHEMA>;
  GRANT SELECT ON <STUDIO_SCHEMA>.FCC_M_COLUMNS TO <GRAPH_SCHEMA>;
  GRANT SELECT ON <STUDIO_SCHEMA>.FCC_M_ATTRIBUTE TO <GRAPH_SCHEMA>;
  GRANT SELECT ON <STUDIO_SCHEMA>.FCC_M_ATTRIBUTE_COLUMN_MAP TO
  <GRAPH_SCHEMA>;
  GRANT SELECT ON <STUDIO_SCHEMA>.FCC_M_COLUMNS_DETAILS TO <GRAPH_SCHEMA>;
  GRANT SELECT ON <STUDIO_SCHEMA>.FCC_M_MAP TO <GRAPH_SCHEMA>;
  GRANT SELECT ON <STUDIO_SCHEMA>.MMG_GRAPH_SCHEMA TO <GRAPH_SCHEMA>;
  GRANT EXECUTE ON SYS.DBMS_LOCK TO <GRAPH_SCHEMA>;
  GRANT EXECUTE ON CTXSYS.CTX_DDL TO <GRAPH_SCHEMA>;
  GRANT EXECUTE ON CTX_THES TO <GRAPH_SCHEMA>;