Skip to main content

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?

 

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

Terms & ConditionsCookie settings