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 (DOT) 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

Michael <gillisme (AT) gov (DOT) ns.ca> wrote


You can't disconnect from a schema, without disconnecting from the database.
This should answer your question.

--
Sybrand Bakker
Senior Oracle DBA

Michael <gillisme (AT) gov (DOT) ns.ca> wrote

Wouldn't the logoff schema trigger fire on an
ALTER SESSION SET CURRENT_SCHEMA
command and the DATABASE one would not.

Ed
(disclaimer, I haven't used these yet, but that is what I'd expect would happen.)