SQL & PL/SQL

Hi,

I have written AFTER trigger to maintain audit information on the table1.
I have my own Audit_Table for this table1.

So changes/transactions on the table1 will be done through the application.

If user1 logs into the application and insert a new record, then the user_name column value in the AuditTable will be "user1".
If user2 logs into the application and update a record/column, then the user_name column value in the AuditTable will be "user2".

Same way...How to get the username for the deleted record?

i.e. If user3 logs into the application and delete the record, so how can capture this user name to store into the Audit table?

Thanks...

Regards,
Suman S