Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Capture a logon in 7.3.4 ?
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