Set_Default_Role_No

From: Jim <somd_jim2002_at_yahoo.com>
Date: 25 Nov 2003 08:15:24 -0800
Message-ID: <1a9cb195.0311250815.4c2b1176_at_posting.google.com>

[Quoted] I have a forms 6i web application which sets roles dynamically based on the login. No problem using dbms_session.set_role.

However, we have a user form which assigns specific roles based upon a user class. I'm using the EXEC_SQL package to grant the roles to the user, but I cannot seem to find away to run the SET_DEFAULT_ROLE_NO proceedure within the form - works fine at the SQL prompt, but that defeats the purpose of the form.

Is there any way to do this within the FMX?

Please do not respond to the email address above - its a spam trap for bots.

Jim Received on Tue Nov 25 2003 - 17:15:24 CET