This discussion is archived
2 Replies Latest reply: Sep 27, 2013 5:16 PM by chijar RSS

knowing if sessions are auditing

chijar Newbie
Currently Being Moderated

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 Guru
    Currently Being Moderated

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

    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?

Legend

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