Forget it. Thanks anyway.
"Ian Wood" <iwood_at_novalistech_.com> wrote in message
news:3Wiv7.26$M%.13696_at_sapphire.mtt.net...
> Hey,
>
> I wish to create a trigger that will remove temporary tables from my
> database when a user exits. I have written a trigger ON_LOGOFF to do just
> that. Works fine so long as the trigger is created by the individual
user;
> however, I wish for this to fire everytime a user ends his session.. Is
> the following correct? Who must create the trigger?
>
> Cheers,
> Ian.
>
>
> CREATE OR REPLACE TRIGGER On_Logoff
> BEFORE LOGOFF
> ON database
> BEGIN
> -- code
> END:
>
>
Received on Fri Oct 05 2001 - 09:48:25 CDT
