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

    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.