home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,580 of 2,288   
   Michael to All   
   DB Logoff vs. Schema Logoff   
   22 Jul 04 19:44:15   
   
   From: gillisme@gov.ns.ca   
      
   Hi,   
      
   I was creating a trigger to fire when a user ends a session, but I see that   
   you could have it fire on a SCHEMA event :   
      
   CREATE TRIGGER "SRU"."TEST" BEFORE   
   LOGOFF ON "SRU".SCHEMA   
      
      
   or a DATABASE event :   
      
      
   CREATE TRIGGER "SRU"."TEST" BEFORE   
   LOGOFF ON DATABASE   
      
   The "Event Type" in both cases is listed as Database, so are these 2   
   different events, or just the same thing listed in 2 different places?   
      
   Thanks,   
      
   Michael.   
      
      
   --   
   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX   
   X Michael Gillis                 X  gillisme@gov.ns.ca         X   
   X Corporate IT Operations        X  902-424-2471               X   
   X Transportation & Public Works  X  http://cito.tpw.gov.ns.ca/ X   
   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca