Re: DB Logoff vs. Schema Logoff

Michael <gillisme_at_gov.ns.ca> wrote in message news:<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
> 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.) Received on Fri Jul 23 2004 - 14:59:22 CEST