Terminate a User Session
We’ve learned through other’s questions how to check for an query for active users via SDK and/or database query.
But does any know how of any creative ways to terminate a user session based off of SDK conditions or database query update?
The only thing I can think of is updating a user status from ‘Active’ to ‘Inactive’ (and guessing that would work to kick a user), but I was seeing if anyone knew of any other ways.
As per my understanding and Oracle documentations, Currently there is no way to manipulate User-Monitor using SDK and they pretty much advise doing it manual way like opening user monitor and terminating the particular user.
From SQL side User_Session tables maps accurately with data shown in monitor but never tried/read if deleting a row from this table will terminate user session.
Also any kind of data-purge w.r.t this table is advised only after shutting down the app server so not sure if it will be useful to delete either.
Do let us know if you get a way out.