Grant Semantic Model Access 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 "RPD_MERGE_USER"."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 "RPD_MERGE_USER"."MY_VIEW" TO "OAX$OAC" WITH GRANT OPTION; Optional: Grant view access to OAX_USER using this SQL: GRANT SELECT ON "RPD_MERGE_USER"."MY_TABLE" TO "OAX_USER";