DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: unable to view audit records

  1. #1
    Join Date
    Mar 2007
    Posts
    4

    Exclamation unable to view audit records

    Hi
    my prob is i am unable to find the audited statements in the AUD$ and its related views (i want to enable auditing for sys user)
    what i did is ...
    1. set an initialization parameter
    audit_sys_operations=TRUE
    and AUDIT_TRAIL=DB
    2. then i restarted the database
    AUDIT create table by sys BY ACCESS;
    3. I connected to user sys as sysdba and i created a table.
    4. then queried the AUD$ but it is giving me no rows selected.

    can anybody tell me what i am doing wrong.how do check the audited statements.any help regarding this is really appreciated.
    thanks in advance
    pras

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    SYS actions are maintained in the O/S audit trail regardless of AUDIT_TRAIL setting.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width