This discussion is archived
8 Replies Latest reply: Sep 6, 2013 3:37 PM by EdStevens RSS

how to noaudit a create session

733414 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points