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,
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
CREATE TRIGGER "SRU"."TEST" BEFORE
LOGOFF ON "SRU".SCHEMA
or a DATABASE event :
LOGOFF ON DATABASE
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 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXReceived on Thu Jul 22 2004 - 21:44:15 CEST