How to audit a table being deleted.

[msuresh]

Hi
I need a help from you all.I have a table where the rows are deleted frequently and i need to find it who is doing this deletion.

I have made the audit_trail to true and i have issued a command

audit all on schema.xxxx whenever successful;

i checked sys.aud$.But i am not getting any idea.If someone who is experienced in this would help me giving me the exact tables or query to check this.

Waiting for your reply.

[JUNE]

Originally posted by msuresh
Hi
I need a help from you all.I have a table where the rows are deleted frequently and i need to find it who is doing this deletion.

I have made the audit_trail to true and i have issued a command

audit all on schema.xxxx whenever successful;

i checked sys.aud$.But i am not getting any idea.If someone who is experienced in this would help me giving me the exact tables or query to check this.

Waiting for your reply.

You could try and use a database trigger, so whenever the row(s) or deleted a another table will be updated with the information

[msuresh]

How can i do this.Can you give me the trigger code for this and what to check.