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 -> Capture a logon in 7.3.4 ?

Capture a logon in 7.3.4 ?

From: Guy van der Werf <gwerf_at_cm-muc.de>
Date: Thu, 27 May 1999 18:41:45 +0200
Message-ID: <374D75C9.28C37296@cm-muc.de>


Hello all,
This old chestnut must have come up before, but....

I need to trigger a stored procedure when a user logs into a 7.3.4 DB. Although possible through application coding (I use Forms, VB and sqlplus), I need something server-side to catch any initial access to the data.

I have a theory about an insert trigger on v$session but this sounds a bit flaky (involving v$ tables). If this IS feasible then is a delete trigger on v$session also possible ?

All and any thoughs on how to implement a solution is greatly appreciated.

P.S. No Oracle8 solutions please. Received on Thu May 27 1999 - 11:41:45 CDT

Original text of this message

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