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

Thread: Auditing

  1. #1
    Join Date
    Jun 2000
    Posts
    26
    I would like to be able to identify which tables have been altered during the previous day (inserts, deletes, updates and structural changes).

    I presume that auditing would provide the information I need, but I have no idea how to go about it.

    I'm running 8i standard edition on NT

    Can anyone help ?

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    audit all on schema_name.table_name;
    The audit entries will be inserted in the sys.aud$ table. Keep an eye on the growth of this table.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    set audit_trail=db in initSID.ora

  4. #4
    Join Date
    Jun 2000
    Posts
    26
    Halo

    Do I need to do this for every table ?

    Or is there something I can set by say, user ?

  5. #5
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    As he mentioned set this value in your initSID.ora file not for every table

  6. #6
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    I believe you would have to do that for every table.

  7. #7
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi
    You have to set initilization parameter file nothing but init.ora file not for every table and u cant set this for every table.U can set this to DB or OS or NONE

  8. #8
    Join Date
    Jun 2000
    Posts
    26
    If I want to turn off audting for a table, what do I do ?

  9. #9
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Once u set the parameter.You have to issue an audit command on the objects what u want to audit.At the same time u have noaudit command for the object which you dont want to audit.

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