Redirect the users to different pages based on users role once they login
orton607Jan 15 2013 — edited Feb 14 2013Hello,
Can anyone please help me with this problem.
I have a application and I wanted to redirect users based on their role. For authentication I am using the in-built application express login credentials and for authorization I have a users table with two fields userid and role. The two roles will be ADMIN and ANALYST.
If an user with ADMIN role login's to the application, he/she should be redirected to Home by default - page 1;
if an user with ANALYST role login's to the application, he/she should be redirected to page 2.
I am using oracle APEX version 4.0.2 and Oracle 10g R2 database.
Any help is appreciated.
Thanks,
Orton