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!

How to enforce a new database session for each new Apex user login

Mikel KOLICIOct 26 2021

Hi,
We have a requirement that for each user login on Apex, the system should create a new dedicated database session for that login. This database session should not server any other user login, not even another login from the same user.
I see that the same db session, which I query through userenv('SESSIONID') or userenv('SID') is used for several Apex users login.
Please advise how to configure Apex so that for each user's login it enforce a new database session.
I am using Application Express 20.1.0.00.13.
Thank you
Mikel

Added on Oct 26 2021

#apex-discussions

12 comments

1,174 views