Re: Trigger on login

From: Komix Hui <huikomix_at_dt.com.hk>
Date: 1997/01/15
Message-ID: <32DD533C.7CC9@dt.com.hk>#1/1

Jurij Modic wrote:
>
> Richard G. Ramirez wrote:
> >
> > Consider adding an INSERT statement to the glogin.sql file.
> > Or enable the AUDIT function.
> >
> > >
> > > Does anybody know if it is possible to create some kind of login trigger
> > > to create a login log table?

> If you add insert statment into glogin.sql it would fire only when
> connecting from sql*Plus. I belive it is not what Roger is looking for.

In initial database parameter file, set: audit_trail=db # audit data inserted to database table AUD$

and immediately after the database startup, following statement is executed:

AUDIT SESSION; Then all logons to oracle (whether success or failure) will be audited.

Best Regards,

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049

Received on Wed Jan 15 1997 - 00:00:00 CST