Re: DEFAULT SCHEMA

On Wed, 04 Feb 1998 01:27:23 GMT, rprendin_at_magi.com (Robert Prendin) wrote:

>You could try
>
>alter session set current_schema = JOE;

Be aware that this is an undocumented feature, which might be changed by oracle at any time!

>
>OR like you said create synonyms....
>
>Robert Prendin
>
>Paul Bennett <bennett_at_cc.gatech.edu> wrote:
>
>>If I have a user called BOB and I want that user to be able to use JOE's
>>tables without specifiying JOE.table_name, how can I do this?
>>
>>I do not want to create public synonyms. I want to specify that the
>>user BOB's defaut schema is JOE.
>>
>>In sybase there can be multiple database, with all users in the database
>>accessing the objects without having to specify a schema. That is what
>>I want to do, but I don't want to create public synonyms, because then
>>everyone in the database will be able to see the table.
>>
>>How can I implement the sybase-esk behavior in Oracle.
>>
>>Thanks.
>>
>>-- Paul
>>
>
Received on Wed Feb 04 1998 - 00:00:00 CST