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

Thread: Auditing

  1. #1
    Join Date
    Jun 2001
    Posts
    150

    Auditing

    Hi
    I want to put some auditing about object changes ,delete and drop object. I read a article on metalink where you can create a trigger which will populate changes in a table but i couldn't find it anymore.

    I don't want to do it for some particle tables but want to do on schema base or on database basis.

    Can someone suggest me best way to do this.

    Ta
    UkDBA

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    If you want to use Triggers...go thru the manuals, you will get an answer.
    On Schema,Database u can have only DDL & Database Event Trigs

    http://technet.oracle.com/doc/server...ch4h.htm#26408
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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