Hi everyone,
I'm using APEX 20.2
I want a list of Logged in Users how to get it?
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Try the below SQL query:
VARSHA
Thank you for the reply Vinish,
How to get for particular Application
Vinish Kapoor
Join the apex_applications view with the above view to get the users for a specific application.
VARSHA
Hi Vinish,
I tried with below code, when i run the code it is giving me all the Applications in the WORKSPACE with no matter which user login to which application. Please help me out...
Select distinct a.USER_NAME, b.APPLICATION_NAME, b.APPLICATION_ID from apex_workspace_sessions a , APEX_APPLICATIONS b
where a.WORKSPACE_NAME = b.WORKSPACE AND a.workspace_name = 'TECDEV'
Vinish Kapoor
You need to add one more condition:
VARSHA
In my workspace i have
Application Names : APP1, APP2 , APP3 and
Application IDs : AID1, AID2, AID3
Users : Usr1, Usr2, Usr3
here Usr1 logged into APP1 but when i run the below code it is showing the Usr1 for Application ID = AID2.
Select distinct a.USER_NAME, b.APPLICATION_NAME, b.APPLICATION_ID from apex_workspace_sessions a , APEX_APPLICATIONS b
where a.WORKSPACE_NAME = b.WORKSPACE AND a.workspace_name = 'TECDEV' AND b.application_id = 'AID2'
VARSHA
I'm using custom authentication in my application
Any help would be highly appreciated...