Re: Q: Trigger when users connect or disconnect ??

In article <4l9c9l$7oq_at_news.nstn.ca> dale_at_fox.nstn.ca (Dale) writes:
>From: dale_at_fox.nstn.ca (Dale)
>Subject: Q: Trigger when users connect or disconnect ??
>Date: 20 Apr 1996 00:48:53 GMT
 

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

What we do is :

• time stamp each row in your "temporary table"
• run a cron job to clean up old timestamped rows

works fine.

Michel lalonde Received on Mon Apr 22 1996 - 00:00:00 CEST