Hi,
i'd like to apply the secure application role to the APEX applications.
for a test, i created a page displaying the content of the table TEST_TABLE
in the region, the sql is select * from test_table.
and i create an process called setrole. the process point is ON LOAD -- BEFORE REGION
it's a pl/sql process, the plsql is
<PRE>
sec_mgr.set_role('APPNAME', 'CLIENT_ID');
</PRE>
when i run this page, i got the error:
<pre>
ORA-06565: cannot execute SET ROLE from within stored procedure.
</pre>
i have set the parsing schema to appuser, which has only connection privilege
the procedure is part of the security framework in our orgnization and it works fine for J2EE applications.
it seems that sec_mgr.set_role('APPNAME', 'CLIENT_ID') cannot be executed.
any ideas?
Thanks
Edited by: user10833860 on May 18, 2011 11:47 AM