In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
emm
Posts: 6 Joined: Mon Nov 10, 2008 6:27 am
Location: Pakistan
Post
by emm » Fri Jan 02, 2009 2:45 am
what query can i use to trace the apps users
Currently the query i use, it returns username as apps for all of them
I want to know the logged in user name
Your help is appreciated
Thanks
admin
Posts: 2063 Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:
Post
by admin » Fri Jan 02, 2009 10:32 am
query v$sessions
lukman
Posts: 170 Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia
Post
by lukman » Tue Jan 06, 2009 12:02 pm
if you just want to know user who currently login then you can use system administration too
latif
Posts: 12 Joined: Wed Jan 24, 2007 1:04 am
Location: United Arab Emirates
Contact:
Post
by latif » Wed Jan 07, 2009 3:46 am
Hi ,
Use below query to know about users logged in apps
select distinct d.user_name from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);
bye
Users browsing this forum: No registered users and 1 guest