Auditing

[UKDBA]

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

[abhaysk]

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