Using Database Roles in conjunction with APEX
aimeesAug 27 2012 — edited Aug 27 2012I have a number of pl/sql applications that use roles for database security. I'm trying to find a way to apply those roles to APEX users.
For example: I've given the execute privilege to a role on a specific package. Then I've assigned the user to that role. When I log into APEX as that user I can't execute that package. However, when I make the package public or give the APEX_PUBLIC_USER the execute privilege on that package my user can launch the package (an HTP based web form).
I've tried both APEX authentication and database authentication and neither seems to work. I'd appreciate any advice that can be offered to solve this problem.
Thank you in advance:
Aimee
APEX Version: 4.1.1.00.23
DB Version: 11g
Web Server: Oracle HTTP Server and mod_plsql