Q: Trigger when users connect or disconnect ??

From: Dale <dale_at_fox.nstn.ca>
Date: 1996/04/20
Message-ID: <4l9c9l$7oq_at_news.nstn.ca>#1/1


I want to be able to tell when a user connects or disconnects so that I may go in an clean-up any results sets that were saved in our "temporary" table (used to hold intermediate result sets of queries).

I believe that I cannot put triggers on the system tables (v$session, etc). Is anyone doing something similar to this? and how?

Thanks in Advance
Babette Dale Underwood (dale_at_fox.nstn.ca) Received on Sat Apr 20 1996 - 00:00:00 CEST

Original text of this message