i am trying to create a form based on a stored procedure (CASH_MOVE). The stored procedure is inside a package (APEX_API).
The package is not in the parsing database schema of APEX application (MO_APEX), but the workspace (MO_APEX) has access to that database schema (MO_401)
and the corresponding APEX parsing schema user (MO_APEX/APEX_PUBLIC_USER) has the EXECUTE privilege on the database package at the other schema (APEX_API).
So what happens is during the wizard execution, at STEP 1 it sees the other schema and i can select the package procedure.
When i press next, it fails with error "User XXX has no privileges on the NNN schema.".
The XXX user though is the APEX developer, that has no schema in the database. I tried by giving also execute rights on APEX_PUBLIC_USER too with no success.
Any idea why this happen?
Does the XXX APEX developer have any schema restrictions in the Accessible Schemas Account Privileges setting in Home > Administration > Users > Edit User?
No, it does not. You mean: Accessible Schemas (null for all) it has no value, ie access to any schema the workspace has access.
Beyond that, at the first step of the wizard i can choose the Database Schema and i can choose the procedure too.
What i notice though is that the user does not have in the Schema list the MO_401 where the package resides access (ie not listed in the combo box),
which means the workspace possibly does not have declared access to this database schema.
Problem has been solved, by adding the Database Schema to those that are accessible by the workspace.