SQL Script List Apps Login Times

Updated: 30-Jul-2002
Version: 1.0

Description

Displays login details of Oracle Apps users

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set verify off
set pages 200

spool apps_login.lst


column sid form 999
column spid for a5 heading "Unix|Serv|Pid" trunc 
column logon_time format a13

column user_name form a12 heading "Apps User"
column description form a35 heading "Description" wrap

select s.SID, p.SPID, to_char(logon_time,'dd-mon hh24:mi')  logon_time
      , f.user_name, u.description
from v$session s, v$process p, FND_SIGNON_AUDIT_VIEW f, FND_USER u
where p.addr = s.paddr
and s.username is not null 
and f.process_spid = p.spid
and f.user_id = u.user_id
/                      

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links