Re: Trigger on login

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.

No, you are right. 99% of the accesses to this database will be using OCI. Thanks anyway. I might try to add a trigger to a system table although I don't like it myself.

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.