Hi Fraz From fnd_logins and fnd_unsuccessful_logins we can know user's attempt login time,but can not know this action happened on which client pc. Best Regards Samuel On Tue, Nov 25, 2008 at 11:41 PM, fraz baig <aesthetic_hunzai@xxxxxxxxxxx>wrote: > > Well for this i think you already have audit reports like > signon audit users > signon audit concurrent progarms > signon audit forms > and signon audit un successfulllogins > if you want to record the up adresses i donto think it is available from > front end in my case for that i have created a trigger > > > ------------------------------ > > Date: Tue, 25 Nov 2008 17:54:54 +0800 > From: malufeng@xxxxxxxxx > To: ora-apps-dba@xxxxxxxxxxxxx > Subject: EBS login auditing issues > > > > Dear ALL > Want to implement an auditing in login page,when user click login button > after input user name/password, > we want to record user name and client IP address and MAC address and > success status(which indicate password is correct or not). > > anyone ever did this before? or any suggestion ,experience or docs > for reference. > > Best Regards > Samuel > > > ------------------------------ > Explore the seven wonders of the world Learn > more!<http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE> >