title: finding the user who deleted the record
body: <p>I have a PL/SQL audit trigger which logs all the changes done to a table. </p>
  
  <p>I am able to find the user_id which inserted/deleted the record. (The user_id comes from a web application, the code for which I don't have access as of now). </p>
  
  <p>so, </p>
  
  <pre><code>TRIGGER AUD_CONFIG_TRG
  AFTER INSERT OR UPDATE OR DELETE ON CONFIG   
  IF INSERTING OR UPDATING THEN
  v_user_value_txt := :NEW.AUDIT_UPDATED_USER_ID;
  </code></pre>
  
  <p>However, for delete, I can't simply use the OLD.AUDIT_UPDATED_USER_ID, and I can't use the new either, since the new record won't be accessible. </p>
  
  <p>I thought about using BEFORE DELETE, but still I can only get an older userid and not the one who deleted this record. </p>
  
  <p>How do I go about if I want to change the rigger such that it can maintain an audit of who deleted the record? Is there someway I can pass this through the code?</p>