Someone has accidently deleted more data than expected from the IJC database. I can't remove the 'delete' privilege on the table, as they will occasionnally need to delete data
I would like to implement an 'audit trigger' (see example below) on the Oracle table, when a row is being deleted
I can find out who is currently logged in to IJC using
wherelogin_time is not null;
But if several users are connected at the same time, is there a way to find out where the delete command has been issued from ?