2 Replies Latest reply: Sep 27, 2013 7:16 PM by chijar RSS

    knowing if sessions are auditing

    chijar

      Hi guys,

      os: solaris 10 X86

      db: RAC 11g r2

       

       

      In my db I have:

       

      audit_trail                          string      DB, EXTENDED

       

      So, I know that audit is in ON but when I query to dba_audit_session only showed me records until the last June.

      For July until now, I don't have any records refering to SESSIONS.

       

      SQL> select OS_Username Usuario_SO,

        2    Username Usuario_Oracle, Terminal ID_Terminal,

        3    DECODE (Returncode, '0', 'Conectado', '1005', 'Fallo - Null',

        4    1017, 'Fallo', Returncode) Tipo_Suceso,

        5    TO_CHAR(Timestamp, 'DD-MM-YY HH24:MI:SS') Hora_Inicio_Sesion,

        6    TO_CHAR(Logoff_Time, 'DD-MM-YY HH24:MI:SS') Hora_Fin_Sesion

        7  from DBA_AUDIT_SESSION

        8  where

        9  (TIMESTAMP between (to_date(to_char('01072013 18:00:00'),'ddmmyyyy HH24:MI:SS'))

      10      and (to_date(to_char('30082013 23:59:00'),'ddmmyyyy HH24:MI:SS')));

       

       

      no rows selected

       

      SQL>

       

      Where can I located if audit for sessions in my databases was deactivated sice July ??

      many thanks.

        • 1. Re: knowing if sessions are auditing
          DK2010

          Hi,

           

          You can Query from following views to know what auditing is enable on your system

           

          dba_stmt_audit_opts

          dba_priv_audit_opts

          dba_priv_audit_opts

           

          In 11g there is option like audit/noaudit command to run after setting the parameter values.

          For more detail you can also check the doc:Verifying Security Access with Auditing

           

          HTH

          • 2. Re: knowing if sessions are auditing
            chijar

            thanks for your response Dk

            but in those views I cannot view anything about AUDIT SESSIONS in the database.

            The link describes those views as:

            DBA_PRIV_AUDIT_OPTS 

            Describes current system privileges being audited across the system and by user

            DBA_STMT_AUDIT_OPTS 

            Describes current statement auditing options across the system and by user

            and when I query to those views they show me object privileges.

             

            Exists another view to see records for audit session option?