-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|