Hi,

We have custom triggers on a few Oracle EBS tables to track & log any insert, update & delete. The trigger captures any changes made through the front end screens. However, if a user does an insert, update or delete to a table in the back end using SQL Plus or any other utilities such as TOAD, SQL Developer, the trigger captures the data that was changed but does not capture the details of the user who made the changes - it just shows up as -1. Is there a way to identify & log the user's user_id / user name, etc along with the data that was changed.

Thanks

SQL> select
  2    user,
  3    sys_context('USERENV','HOST'),
  4    sys_context('USERENV','OS_USER')
  5  from dual;

USER
------------------------------
SYS_CONTEXT('USERENV','HOST')
-----------------------------------------------
SYS_CONTEXT('USERENV','OS_USER')
-----------------------------------------------
MCDONAC
ORADEV\COMCDONA-AU
COMCDONA-AU\comcdona