| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> DB Logoff vs. Schema Logoff
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 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXReceived on Thu Jul 22 2004 - 14:44:15 CDT
![]() |
![]() |