Ensure that the OAX$OAC user can access each of the database objects that
you plan to merge.
- Grant access to the OAX$OAC user to each object using this SQL:
GRANT SELECT ON "CUSTOM_SCHEMA"."MY_TABLE" TO "OAX$OAC";
- If you plan to merge views that reference multiple schemas, use the WITH GRANT
OPTION as follows:
GRANT SELECT ON "CUSTOM_SCHEMA"."MY_VIEW" TO "OAX$OAC" WITH GRANT
OPTION;
- Optional: Grant view access to OAX_USER using this SQL:
GRANT SELECT ON "CUSTOM_SCHEMA"."MY_TABLE" TO "OAX_USER";