Hello All, I was trying to get the role infomation from outside database(our Remedy working with db_link). I got the roles creating a SQLMENU.
my problem is: We have a unified ticketing system that works for different types of tickets authenticating login name and check role from outside database. My roles like: A and B User may have one role or multiple roles, when user clicks on the ticket it has to makesure that is right ticket based on user role(s). If user has single role, it is working good. if user have multiple roles, i getting stuck here. when i create a AL, it is working only using first role which is in the list. Can anyone explain me how it works if user has multiple roles. Appreciate your help.... Thanks Mani _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"