Re: DEFAULT SCHEMA

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 1998/02/04
Message-ID: <01bd3167$79613c50$48c3657e@polcar_nt4005>#1/1

If you do it like this:

connect joe/....
grant select on <anytable> to bob;
connect bob/...
create synonym <anytable> for joe.<anytable>;

then only BOB will see JOE's tables, using the same names for them.

Hope this helps,

---
Pavel Polcar

Paul Bennett <bennett_at_cc.gatech.edu> wrote in article
<34D77042.2A5DF985_at_cc.gatech.edu>...


> 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