Re: ON-LOGON Trigger ??

fitzjarr..._at_cox.net wrote:
> Robert Bralic wrote:
> > Hallo,
> >
> > I would likre to write in PL/SQL small tool for
> > dba-s,that will note from "V$SESSION" for any,
> > login username and other datas into a table,
> > something like "last" on UNIX, but I don't know
> > how to write and compile this function with that
> > trigger(ON-LOGIN, if this exysts), so I need
> > a little help.
> >
> >
> > Thanks in advance, Robert !
> > robert.bralic_at_si.t-com.hr
>
>
> It has been done before, and such code is available in "Oracle9i:
> PL/SQL Programming", by Scott Urman. You can download the code he's
> written here:
>
> http://shop.osborne.com/cgi-bin/oraclepress/downloads.html
>
> LogPkg1.sql and LogPkg2.sql are what you need to use. Stop trying to
> re-invent the wheel.
>
>
> David Fitzjarrell

My mistake, it's LogGonnects.sql and LogPkg1.sql you need.

David Fitzjarrell Received on Wed Jul 27 2005 - 07:54:30 CDT