Dear,
We are trying to get maximum information by enabling auditing within database. But facing some problem with setting option for auditing. We can't just enable audit_trail=db,extended and enable auditing on every object by access.
1.If we enable,db,extended and enable audit by session on objects, then you would not get the information what was done on the table and which value was changed.
2.Or, if we enable only db, then we will not get the operation type was performed on table,definitely not the value.
3.But if we enable db,extended ,and audit by access,than we will get the information. But it will reveal the sensitive information as
well which is really a thread.
So, my question is , as there are many oracle guys are here, how are you performing you auditing for your databases?? I am expecting it would help many of us to determine the better way to do same.
Regards,