Hi everyone,
I created custom user access control , in this i want to restrict each user to one session, that is once the user login if he doesn’t logout he can not login once again, One user can have a single session
How do i do this?
Any help would be highly appreciated…
Petar Simic
You can take a look here: https://stackoverflow.com/questions/58665262/how-to-logout-sessions-in-oracle-apex
VARSHA
Thank you for the reply Petar Simic,
I tried the process in the link you mentioned, in that they have not mentioned the 'Process Point' while creating Application Process, for that i have given "On Load: Before Header" . when i try to login it is throwing an error saying that
"ora_sqlerrm: ORA-01403: no data found ORA-06512"
and if i mention process point as "On New instance(new session) and when i try to login it is throwing error as Invalid login credentials.
What I'm i missing here?
Petar Simic
I think that you should create an application process with the point after authentication.
VARSHA
I have given the process point as After Authentication as you suggested , when i try to login it is throwing an error " Invalid Login Credentials".
I'm using Custom Authentication and User Access Control.
VARSHA
I tried with Process point as "After Authentication", when i try to login it is allowing and inserting data to table(MOST_RECENT_LOGIN) .
then i tried to login using same login credentials in another system, it's logged in and updating the table with session id and login date which it should not do.
i want to display a message saying that "user already logged in"