Grant Semantic Model Access
Ensure that the OAX$OAC user can access each of the database objects that you plan to merge.
Ensure that the OAX$OAC user can access each of the database objects that you plan to merge.
GRANT SELECT ON "CUSTOM_SCHEMA"."MY_TABLE" TO "OAX$OAC";
GRANT SELECT ON "CUSTOM_SCHEMA"."MY_VIEW" TO "OAX$OAC" WITH GRANT
OPTION;
GRANT SELECT ON "CUSTOM_SCHEMA"."MY_TABLE" TO "OAX_USER";