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

    Setting Database Roles using DBMS_SESSION.Set_Role in ADF

    969955
      Hello:

      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 11.1.2.3, 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.