Re: DB Logoff vs. Schema Logoff
From: <sybrandb_at_yahoo.com>
Date: 23 Jul 2004 01:03:11 -0700
Message-ID: <a1d154f4.0407230003.5d5502a5_at_posting.google.com>
Date: 23 Jul 2004 01:03:11 -0700
Message-ID: <a1d154f4.0407230003.5d5502a5_at_posting.google.com>
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.
You can't disconnect from a schema, without disconnecting from the database. This should answer your question.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Jul 23 2004 - 10:03:11 CEST