Our current installation is Apex 3.2 and has a separate parsing schema from the main schema that owns the objects. All the objects owned by the main schema are given direct grants so that the applications can access those objects.
We are in the process of migrating to the latest Apex 4.2 (Or hopefully the next 5.x release as it becomes available).
The requirement is to Remove ALL direct grants and provide GRANTS TO A ROLE. Then Grant that role to the parsing schema when we migrate to Apex 4.2.
Can Apex 4.2.3 support Indirect Grants via ROLES to the parsing schema?
Target Environment: Oracle 11gR2 RAC, Oracle Apex 4.2.2, Oracle HTTP server (OHS) and not Listener.