Re: [Q] Associating users to schemes

You'll need to use synonyms for this purpose either private or public synonyms
create public synonym emp for scott.emp

etc.

That's the only way to do it, AFAIK

Hth,

Sybrand Bakker, Oracle DBA

"Nikolaus Rumm" <nospam_rumm_at_culturall.com> wrote in message news:M_075.25128$5k.338059_at_news.chello.at...
> 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 Fri Jun 30 2000 - 00:00:00 CDT