Ref (User's login information)

[atkinson]

Hi,

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.,).

Thanks,

[samdba]

Hi,

AFIK, there is no such table provided by Oracle. I wrote foll. qry to get reqd.info.

select
l.login_id,
u.user_name,
start_time,
end_time,
l.pid,
l.spid,
l.process_spid,
s.sid
from
apps.fnd_logins l,
apps.fnd_user u,
v$process p,
v$session s
where
l.user_id=u.user_id
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.

Thanks,

[DaPi]

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.