Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with logon trigger
On Tue, 15 Jan 2002 21:29:16 +0800, "Hemant K Chitale"
<hkchital_at_singnet.com.sg> wrote:
>Sybrand,
>
>As with many of your postings you do seem to be
>behind the times. The Logon trigger (actually
>database event trigger) is new (8i) ;
>the audit feature is old.
>There are good reasons for using database triggers.
>e.g. using database triggers for logon auditing
>you can setup your own audit table, do not need
>to worry about relocating SYS.AUD$ out of the
>SYSTEM Tablespace, you can write your own
>PLSQL code to authenticate/disallow users etc.
>Look up Note 74173.1 on Database Event Triggers in 8i.
>
>Hemant K Chitale
Thank you for such a *nice generic * comment.
I really appreciate it.
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Wed Jan 16 2002 - 12:51:26 CST