DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Ref (User's login information)

  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45

    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,

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    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

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
  •  


Click Here to Expand Forum to Full Width