2 Replies Latest reply: Oct 31, 2010 2:19 AM by user12052956 RSS

    dba_priv_audit_opts  not changed after audit statement - help needed

    user12052956
      Hi,
      im trying to understand what im doing wrong.
      oracle 11.2
      from sys:

      SQL> audit session whenever not successful;

      Audit succeeded.

      SQL> audit create session whenever not successful;

      Audit succeeded.

      SQL> select * from dba_priv_audit_opts where privilege like '%SESSION%';

      USER_NAME PROXY_NAME
      - - - - - - - - - - - - - - - - - - - - -
      PRIVILEGE SUCCESS FAILURE
      - - - - - - - - - - - - - - - - - - - - - - - - - - - -
      CREATE SESSION              BY ACCESS  BY ACCESS


      why wasn't it changed ?   I want only failures logons to be audited.