I am need on retrieve user uaditing on oracle forms and reports 11g
I have oracle forms and reports application with custom login form
I have have various type of user in my database
in middle of my application ( after 3 sequenece ) form1 (login form) calls form 2 then secnd form calls form3
In the form 4 I have button and according to user loged in I want call 3 type of forms
if user test call form 1
if user test 1 call form 2
if user test 3 call form 3
I need pl sql code when button pressed for the case user logged in call form1 another user log in call form2
Any help would be appreciated