2 Replies Latest reply: Dec 28, 2012 1:45 PM by 969955 RSS

    Setting Database Roles using DBMS_SESSION.Set_Role in ADF


      In Oracle Forms, on logon, we use DBMS_Session.set_Role() to set the Database Roles that grant user access to various database tables.

      Now in Jdev, RedHat 5.8, we want to perform the same functionality in ADF Fusion Applications.

      In ADF, where would we put the call to DBMS_SESSION.SET_ROLE()?

      Is there a better way to accomplish this functionality?

      Thanks for the help.