Re: Different user can't see the otherones tables

From: Aravind Yalamanchi <ayalaman_at_yahoo.com>
Date: Tue, 08 Feb 2000 11:50:48 -0500
Message-ID: <38A04967.7EF52DEC@yahoo.com>

Tablespace does not control what a user can see and cannot see. In your case, the owner of the table has to grant select (and other privileges) to the other users. Also if you want the other users to access these tables with out schema extensions, you can use synonyms

SVRMGR> connect a/a
Connected.
SVRMGR> create table tab1 (a int, b int); Statement processed.
SVRMGR> insert into tab1 values (1,2);
1 row processed.
SVRMGR> insert into tab1 values (1,2);
1 row processed.
SVRMGR> insert into tab1 values (1,2);
1 row processed.
SVRMGR> commit
Statement processed.
SVRMGR> connect b/b
Connected.
SVRMGR> select * from tab1;
select * from tab1

              *
ORA-00942: table or view does not exist SVRMGR> connect a/a
Connected.
SVRMGR> grant select on tab1 to b;
Statement processed.
SVRMGR> connect b/b
Connected.
SVRMGR> select * from tab1;
select * from tab1

              *
ORA-00942: table or view does not exist SVRMGR> select * from a.tab1;
A B
---------- ----------

         1          2
         1          2
         1          2

3 rows selected.
SVRMGR> create synonym tab1 for a.tab1; Statement processed.
SVRMGR> select * from tab1;
A B
---------- ----------

         1          2
         1          2
         1          2

3 rows selected.
SVRMGR> Dirk Poppke wrote:

> Hi there!
>
> I want different users to work on the same tables.
> Anybody should see the tables of anybody. Therefore, I created a
> Tablespace and set it as the default Tablespace for every user.
>
> Nevertheless, every user can only see its own tables.
> What's wrong?
>
> Thanks,
> Dirk
Received on Tue Feb 08 2000 - 10:50:48 CST