Re: ON-LOGON Trigger ??

From: <fitzjarrell_at_cox.net>
Date: 27 Jul 2005 05:51:29 -0700
Message-ID: <1122468689.416115.169070@z14g2000cwz.googlegroups.com>

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 Received on Wed Jul 27 2005 - 07:51:29 CDT