Application Express 5.1.4.00.08
I cannot modify an APEX Data Loader table lookup because APEX is checking access to the target table using the APEX user instead of the parsing schema. The table owner schema (AR) granted select access on table (HZ-GEOGRAPHIES) to the parsing schema (XXAA), and when the data loader runs, it behaves properly.
When I try to change the lookup in any way, I get this message:
User SSTRAUS has no privileges on the AR schema.
Contact your application administrator. Details about this incident are available via debug id "347737".
Return to application.
SSTRAUS is the current APEX development environment user. Co-incidentally, there is an SSTRAUS schema.
What's going on and are there any work arounds?
Thanks,
Skip