Grant Semantic Model Access

Ensure that the OAX$OAC user can access each of the database objects that you plan to merge.

  1. Grant access to the OAX$OAC user to each object using this SQL:
    GRANT SELECT ON "X_FAW_MERGE_POC"."MY_TABLE" TO "OAX$OAC";
    COMMIT;
  2. If you plan to merge views that reference multiple schemas, use the WITH GRANT OPTION as follows:
    GRANT SELECT ON "X_FAW_MERGE_POC"."MY_VIEW" TO "OAX$OAC" WITH GRANT
              OPTION;
    COMMIT;
  3. Optional: Grant view access to OAX_USER using this SQL:
    GRANT SELECT ON "X_FAW_MERGE_POC"."MY_TABLE" TO "OAX_USER";
    COMMIT;