0 Replies Latest reply on Oct 29, 2013 7:54 PM by NirmalSArri

    Auditing a proxy user.


      I am having trouble figuring out the best way to audit a proxy user. Here is the situation:


      1. user nsarri is created and following auditing features are enabled:
        1. audit all by nsarri by access;

        2. audit update table, insert table, delete table,execute procedure by nsarri by access;

      2.    There is a user called APPLICATION_USER which is NOT audited.
      3. nsarri is given proxy to connect to APPLICATION_USER
        1. alter user APPLICATION_USER grant connect through nsarri;
      4. nsarri can now connect to APPLICATION_USER and run update/delete/create/drop etc
      5. I need to know what nsarri did while it was connect to APPLICATION_USER as a proxy.


      What is the best way to achieve this?


      Thanks in advance.