Re: Capture a logon in 7.3.4 ?

Guy van der Werf wrote in message <374D75C9.28C37296_at_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.
>

Your theory seem reasonable since triggers cannot fire based on creating session with the database. You could also audit CREATE SESSION and create trigger on the AUDIT table to check on when the target users log on.

Since triggers fires only for INSERT, DELETE, UPDATE, to trigger a procedure when users connect, the above thoeries might be the only way. Then, again, someone else may have other ideas.

Good luck!

just my 2 cents..
wozi_at_dhc.net Received on Thu May 27 1999 - 15:15:24 CDT