Re: DEFAULT SCHEMA

In article <34D77042.2A5DF985_at_cc.gatech.edu>, Paul Bennett wrote:

If you do not want public synonyms, then why not private synonyms for each user, and ROLES for the schema's permissions.

The major problem with private synonyms is the maintenance of them.

Additionally, the SHARED_POOL entry for one user's SQL is not the same as the SHARED_POOL entry for another user's identical when using private synonyns.

Finally, everyone will not be able to see the table if you do not grant them any priv's on it, so PUBLIC synonyms would work then...

regs

Neil Chandler

>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