470,864 Members | 2,005 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,864 developers. It's quick & easy.

DB Logoff vs. Schema Logoff

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
Jul 19 '05 #1
2 4365
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
Jul 19 '05 #2
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.)
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Arun Goel | last post: by
6 posts views Thread by =?Utf-8?B?Zmh1bnRlcg==?= | last post: by
3 posts views Thread by =?Utf-8?B?Zmh1bnRlcg==?= | last post: by
2 posts views Thread by Michael | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.