DB Logoff vs. Schema Logoff

From: Michael <gillisme_at_gov.ns.ca>
Date: Thu, 22 Jul 2004 19:44:15 GMT
Message-ID: <Xns952EAA45FE5BAgillismegovnsca_at_198.164.200.20>



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_at_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
Received on Thu Jul 22 2004 - 21:44:15 CEST

Original text of this message