Re: multiple schemas per user - possible?

> But what you are apparently looking for is
>
> ALTER SESSION SET CURRENT_SCHEMA=B.
>
> Now reference to TBL will point to B.TBL.

That sounds about like what I'm looking for, I'll try it out as soon as I get a chance.

Thanks for the info.

>
> You will remain user A though, only the unqualified references will be
> resolved differently. Therefore object privileges are still those of
> user A.
>
> Jaap.
>
Received on Tue Sep 17 2002 - 18:21:23 CDT