CODEWITHSUNDEEP
oracle-apexoracle-apex-5.1
A.K.
A.K.

Reputation: 11

Log out users from Oracle APEX 5.1. from the server side

I use Oracle Apex 5.1 + Ora 18XE. Could some one suggest a way how to log-out particular users in the system in particular but not the same moment of time. It might be session expire "force" or raise specific apex exception which stops the engine for that user(s). Change Authorization procedure is not preferred way, because a log out depends on user activity. App consists of 50 pages and 100 users.

Upvotes: 0

Views: 1717

Answers (3)

A.K.
A.K.

Reputation: 11

Thanks for your attention and suggestions.

After some tests we've decided to use apex application process + pl/sql logic and finally APEX_AUTHENTICATION.LOGOUT.

unfortunately, we did not find any supported way to logout users from the "server side".

Upvotes: 1

Dominik
Dominik

Reputation: 1032

You can query the apex internal table directly:

SELECT * FROM apex_workspace_sessions;

You could then also delete a Session like that...

DELETE FROM APEX_050100.wwv_flow_sessions$ WHERE ID = :ID;

Note that this is unsupported and might not work anymore in the future. It will also bypass logout procedures, although you could implement that manually while deleting.

Upvotes: 0

Joe
Joe

Reputation: 3347

There is a set of APEX PL/SQL APIs here. Check out Delete Session.

Upvotes: 0

Related Questions