title: Audting in Oracle 11g release 2
body: <p>We have set audit_trail to DB, extended.I m trying to restrict the audit for specific users. But all users(objects) DML operations are auditing by default.</p>
  
  <p>I tried to stop the auditing using all these statements:</p>
  
  <pre><code>SQL&gt; NOAUDIT ALL;
  
  Noaudit succeeded.
  
  SQL&gt; NOAUDIT ALL ON DEFAULT;
  
  Noaudit succeeded.
  
  SQL&gt; NOAUDIT SESSION;
  
  Noaudit succeeded.
  
  SQL&gt; noaudit select any table by X;
  
  SQL&gt; noaudit all by X;
  </code></pre>
  
  <p>But its still auditing all dml operations(for x schema also)</p>
  
  <p>There are no audit policies and i see below output from below statement</p>
  
  <pre><code>SELECT * FROM DBA_PRIV_AUDIT_OPTS UNION SELECT * FROM DBA_STMT_AUDIT_OPTS;
  
  null EXEMPT ACCESS POLICY By Access By Access
  </code></pre>
  
  <p>So i disabled it too</p>
  
  <pre><code>noaudit EXEMPT ACCESS POLICY;
  </code></pre>
  
  <p>Oracle 11g Release 2 Database is running on 64 bit CentOS.</p>
  
  <p>Please let me know,is this default behavior of 11g database.If yes,Is there any way i can restrict it.</p>
  
  <p>Your help is really appreciated.</p>
  
  <p>Thank You!</p>