Re: Weird "CURRENT_SCHEMA" behavior

From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 4 Nov 2009 18:36:40 +0000 (UTC)
Message-ID: <pan.2009.11.04.18.36.39_at_email.here.invalid>

On Wed, 04 Nov 2009 19:07:29 +0100, Maxim Demenko wrote:

> Mladen Gogala wrote:

>> The "ALTER SESSION SET CURRENT_SCHEMA" used to only influence the name
>> resolution. In version 10.2, it also influences the owner of the newly
>> created objects:

>

>> This is strange! I observed the same behavior in 11.2 database.

>
> I observed the same behaviour in 8i and 9i databases as well. Maybe,
> this is expected behaviour?
>
> ;-)
>
> Best regards
>
> Maxim

I can't point to the article, but I do remember reading that it should only change the name resolution. I also tested it on a 9i database and it works as above. This is, apparently, the expected behavior.

-- 
http://mgogala.freehostia.com

Received on Wed Nov 04 2009 - 12:36:40 CST