Can I use dbms_session.set_role within AE?
408658Jun 6 2006 — edited Jun 6 2006I am augmenting an existing application with AE. The existing security scheme validates the user, then enables a role (with password) that has been granted update privs for all of the tables in the system. My AE application uses database authentication so users are uniquely identified in the database (no user or password appears in the DAD entry). When I try to duplicate the security functionality in AE, I get "ORA-06565: cannot execute SET ROLE from within stored procedure". Is there a way to accomplish this?
Secondly, even without enabling the role, the application seems to work even though it should not. When using the same user to connect thru Toad, updates are not allowed. Modifications made thru the application use the "user" psuedocolumn and the user is identified correctly (not HTMLDB_PUBLIC_USER) and the user is not set in AE as a user or developer.
I'm confused.
Bob