8 Replies Latest reply: Sep 6, 2013 5:37 PM by EdStevens RSS

    how to noaudit a create session

    733414
      We turned this on in 10.1.0.3. I am not sure when it was done or exactly what command. however, the noaudit is not turning tihs off.
      We are currently in 11.1.0.7

      what is the noaudit command to turn this off?

      noaudit create session does not work. Please see below.

      SQL> select * from dba_stmt_audit_opts
      union
      select * from dba_priv_audit_opts;
      2 3
      USER_NAME PROXY_NAME
      ------------------------------ ------------------------------
      AUDIT_OPTION SUCCESS FAILURE
      ---------------------------------------- ---------- ----------
      ANY CLIENT
      CREATE SESSION BY ACCESS BY ACCESS


      SQL> noaudit create session;

      Noaudit succeeded.

      SQL> select * from dba_stmt_audit_opts
      union
      select * from dba_priv_audit_opts;
      2 3
      USER_NAME PROXY_NAME
      ------------------------------ ------------------------------
      AUDIT_OPTION SUCCESS FAILURE
      ---------------------------------------- ---------- ----------
      ANY CLIENT
      CREATE SESSION BY ACCESS BY ACCESS