Just some basic information needed, but can see information stored in - fnd_session_runtime table, but it only holds recent calls.
Thinking about putting an event in that populates a CLU to hold informaiton but feel its overkill.
Any simple way?
Question
Apps9: Is there a way of finding when a user logs on for the first time and when they log out?
This topic has been closed for comments
You can enable the audit in the database and later query dba_audit_trail. You do need the sys admin rights, though.
Hi
dba_audit_trail doesn’t appear to show the IFS Logins but just the direct database logins using tools such as PL/SQL Developer. Unless there is a setting which needs changing?
Please provide guidance
Regards
Shaun
Once your parameter ‘audit_trail’ in the database is set to ‘DB’ and you’ve enabled audit_trail, you should be able to query dba_audit_session. The username will list all your users that have logged in the database since your audit starts. These users should be same as your IFS logins.
Cheers,
Wen
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.