Re: [Q] Associating users to schemes

You can try

alter session set current_schema = SCOTT

Hope this helps.

Igor

Nikolaus Rumm wrote:
>
> Hello,
>
> is it possible to associate new users with a scheme, such that they can
> access the scheme's tables without prefixing the schema-name, i.e. SELECT *
> FROM EMP... and not SELECT * FROM SCOTT.EMP ?
>
> My problem is that I have many unqualified references to tables in my
> deployment descriptors and I don't want to change them all to fully
> qualified references. I know I could do this with aliases, but that sound a
> little bit awkward to me.
>
> The best solution for me would be to associate the users to the scheme.
>
> Any suggestions ?
Received on Sat Jul 01 2000 - 00:00:00 CDT