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

Thread: Sys.Aud$ --- Auditing - Urgent

  1. #1
    Join Date
    Nov 2001
    Location
    India
    Posts
    6
    Hi Friends


    SCENERIO
    ------------
    I have set the auditing options for my oracle 8i database.
    I have added a parameter "Audit_Trail = True" in init.ora.

    I have set System, Statement, and Object auditing options in my system.

    Auditing Trail Records are stored in SYS.AUD$ table. There are 1047 records in sys.aud$ table.

    QUERY
    --------
    How will I know, which audit trail records belong to System auditing, Object Auditing and Statement Auditing? I am not able to decide how should I delete System, Object, Statement audiitng records separately with 3 delete statement....

    It would be great help.

    Thanks in advance.

    Please let me know if u want any more information on it

    Dharmesh
    dharmesh.bangali@hsoftcon.com

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Hi,
    Look this link:
    http://www.elementkjournals.com/dbm/9801/dbm9811.htm

    USE
    sys.dba_audit_object
    sys.dba_audit_statement
    SYS.DBA_AUDIT_SESSION

    [Edited by kgb on 11-08-2001 at 11:11 AM]
    Best wishes!
    Dmitri

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