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?
This topic has been closed for replies.
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.