-
Ref (User's login information)
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,
-
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,
Sam
------------------------
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|