Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> DB Logoff vs. Schema Logoff

DB Logoff vs. Schema Logoff

From: Michael <gillisme_at_gov.ns.ca>
Date: Thu, 22 Jul 2004 19:44:15 GMT
Message-ID: <Xns952EAA45FE5BAgillismegovnsca@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 - 14:44:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US