DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: AUDIT on a table for everyone except one !!

  1. #1
    Join Date
    Nov 2002
    Posts
    170

    AUDIT on a table for everyone except one !!

    Is it possible to audit everyone except for one user on a certain DB object.

    EG: Is it possible (I don't want to audit XXX for accessing the table but everyone else).

    audit select,insert,delete,update on OWNER.TABLE_NAME;
    noaudit select,insert,delete,update on OWNER.TABLE by XXX;

    -- I'm getting the following error on the second statment.
    ERROR at line 1:
    ORA-01708: ACCESS or SESSION expected

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Issue goes a little deeper.

    The NOAUDIT option only negates an audit statement with the same syntax.

    It is not possible to exclude certain users from current audit options unless the original audit statement included the "BY" clause.

    You can always issue AUDIT command specifying the list of users you want to audit, it can be painful but it can be done.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2002
    Posts
    170
    So what's the syntax to audit user A,B, C for select ,update,delete on owner.table_name ?

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    audit select table, update table, delete table by UserA, UserB, UserC by access;
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width