Re: Granting table privileges. Possibly Jonathan Lewis can advise here?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Thu, 10 Apr 2003 22:36:22 +0200
Message-ID: <6alb9vs1fnkkmair4k1g6lmlskh2k7in21@4ax.com>

On Thu, 10 Apr 2003 00:14:22 +0100, "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:

...
>Folks; By all means correct me if I'm wrong, but since a *long* while back,
>with the 'BECOME USER' privilege, one has been able to issue 'alter session
>set current_schema = nnnnnn' and grant object privileges as necessary.
...
'set current_schema' only changes the way unqualified references (without a schema reference) are resolved. It does not change the privileges of the session.

Jaap. Received on Thu Apr 10 2003 - 15:36:22 CDT