Was going through this and found that “AUDIT DELETE ANY
TABLE BY <username> BY ACCESS” or “AUDIT UPDATE ANY TABLE
<username> BY ACCESS” enable audit for delete and updates for given username/schema.
I want to enable auditing on delete and update on my entire
database.
Please suggest the best possible solution? Why? And have we
tested it in our any of existing setup?
I am thinking of “Trigger after delete” but again this logic
gets struck at individual tables. It do not work simply once and all for
complete database/all users/all schemas