4 Replies Latest reply: Apr 12, 2012 12:28 PM by 889367 RSS

    Audit an object by user

    889367
      I tried finding this answer first in documentation and on here but no luck.

      I can do:

      AUDIT UPDATE TABLE BY USER_1,USER_2;
      AUDIT UPDATE ON USER_1.TABLE_1 BY SESSION;

      but I want to set auditing by object and by user, is that possible?

      I've tried
      AUDIT INSERT,UPDATE,DELETE ON USER_1.TABLE1 BY USER_2,USER_3;

      but i get errors...
      ORA-01708: ACCESS or SESSION expected

      Do I have to use Fine Grain Auditing for this?

      Thanks