I have this urgent req.
I need to come up with a wrapper to audit DML activities on specific tables ( I may be calling package/procedure on each of those table's triger) by some users after checking their profile.
Its been very long time I have written pl/sql code, Can you guys help me come up with some thing in short time.
I need database trigger , which calls the wrapper for DML activity of specific table.
It should be an autonomous transaction.
I need to log the username, timestamp, terminal, machine, type of DML operation , and SQL statement that user issued.
Appreciate your help sincererly,