Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deny multiple simultaneous authentication for a single user

Stefano_i0600006Mar 22 2013 — edited Mar 25 2013
This question has already been asked long time ago in this thread 3470854 but was not given a clear answer.

I want to deny multiple login for the same user (Username - APP_USER) (from different browsers/machines etc).
In practice, i would like to allow a user to have only one "active" apex session. All owners of active apex session (to understand the session in Administration>Monitor Activity>Active Sessions) must be distinct.

If it already exists an active session for the user who wants to log in, I want to show a warning message like: "there is already an application session active for user xxx, going forward will close the current session and open a new session".

Are there any API or db views to test this condition?

Thanks,
Stefano
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2013
Added on Mar 22 2013
20 comments
4,335 views