before logoff trigger 
Author Message
 before logoff trigger

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:



Tue, 23 Mar 2004 21:51:59 GMT
 before logoff trigger

Forget it.  Thanks anyway.


Quote:
> 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:



Tue, 23 Mar 2004 22:48:25 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How can I totally capture logoff trigger?

2. BEFORE LOGOFF Trigger question

3. How can I "totally" capture the logoff trigger?

4. User Logon/Logoff

5. Inactivity logoff?

6. Logoff User Code

7. ShutDown, Logoff, Restart ? How

8. Looking for an auto-logoff procedure

9. Timer-Driven Auto Logoff

10. App Dev Question: To logoff or stay connected?

11. automatic logoff after inactivity

12. OAS PL/SQL Logoff


 
Powered by phpBB® Forum Software