Regarding audit in EBS 12.2

Posted by VinodN on Mar 21, 2024; 9:21am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Regarding-audit-in-EBS-12-2-tp12371.html

Hello Erman! I have some questions regarding audit in an EBS instance:

1. How can we enable audit for activities done by admin users (SYSADMIN and users with System Administrator, System Administration privileges) and how can we see the audit logs?

2. Suppose there is a table PER_ALL_PEOPLE_F and we want to audit insert, update, delete on it. We can enable database audit on it and also we can do it by setting up audit trail in the application tier. So which of these is the right/better way to do it? What is the difference between the logs captured by database audit Vs by EBS audit trail?

3. How can we log all inserts, updates, deletes performed by a front end user?