Re: trigger on oracle meta-model tables

From: Richard Luther <100136.2447_at_Compuserve.com>
Date: 1998/02/07
Message-ID: <34DC4947.3FF3@Compuserve.com>#1/1

Pascal Chatard wrote:
>
> Hi
>
> I would like to know how to create a trigger on meta-model tables
> (object Obj$, col$ ... created by bsq.sql script) to catch user creation
> or login to the database ???
>
> please reply to my email adress (Hynes_at_lyon.archi.fr)
>
> thanks in advance
>
> pascal

Hello, If you do not want to re-invent the wheel but AUDIT then check out Oracles own AUDIT options. You can then what you want ( object auditing ) and when you want ( when success, notsuccess, both ) and so on.

Hope this helps

PS: ( Internal table names like OBJ$ and OBJ# are NOT portable and may not be the same between oracle versions )

R. Luther Received on Sat Feb 07 1998 - 00:00:00 CST