Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ON-LOGON Trigger ??

Re: ON-LOGON Trigger ??

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 27 Jul 2005 13:25:47 GMT
Message-ID: <Xns96A0416AF6BB4SunnySD@68.6.19.6>


"Robert Bralic" <robo_bralic_at_yahoo.co.uk> wrote in news:dc7tsm$ng4$2_at_ss405.t-com.hr:

> 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
>
>

IMO, it would be MUCH easier to simply AUDIT new sessions. Received on Wed Jul 27 2005 - 08:25:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US