Re: Weird "CURRENT_SCHEMA" behavior
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 04 Nov 2009 19:07:29 +0100
Message-ID: <4AF1C2E1.7040105_at_gmail.com>
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:
Date: Wed, 04 Nov 2009 19:07:29 +0100
Message-ID: <4AF1C2E1.7040105_at_gmail.com>
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 Received on Wed Nov 04 2009 - 12:07:29 CST