DB Logoff vs. Schema Logoff

[Michael]

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 gi******@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

[sybrandb]

Michael <gi******@gov.ns.ca> wrote in message news:<Xn*****************************@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.

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

--
Sybrand Bakker
Senior Oracle DBA

[Ed prochak]

Michael <gi******@gov.ns.ca> wrote in message news:<Xn*****************************@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.

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.)