Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table audit without knowing Developers

muba_zakMar 29 2018 — edited Apr 2 2018

Hi Experts,

I need to audit particularly 5 tables ( insert update delete)  old & new values to store in a separate table. But Developer should not know that tables are being auditing.

audit_trail = DB

what are all the options that i can audit.

i could use triggers , but developer come to know the the triggers .

is this option helps me "audit_trail=db, extended" ? but i doubt database performance.

please suggest me the correct solution

Regards,

Muba

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2018
Added on Mar 29 2018
13 comments
448 views