Ref (User's login information)
Could some one tell me which table I can access to get the information of users logon to the oracle applications (i.e., user_id, SID etc.,).
AFIK, there is no such table provided by Oracle. I wrote foll. qry to get reqd.info.
and l.pid = p.pid
and p.addr = s.paddr
and trunc(start_time) = trunc(sysdate)
order by l.login_id
Hope, it helps you also.
To handle yourself, use your head. To handle others, use your heart
You said users, did you mean users' or user's ?
For the current user, look at the function SYS_CONTEXT in the SQL manual, otherwise v$session is a start.
Click Here to Expand Forum to Full Width