Re: Different user can't see the otherones tables

Each user must grant select and other privileges to the other users or to public if you want all users can see other's tables.

The tablespace defines only the storage space not the access rights.

--
Have a nice day
Michel

Dirk Poppke <poppke_at_iug.cs.uni-dortmund.de> a écrit dans le message : 87pet0$bkf$1_at_fbi-news.cs.uni-dortmund.de...
> 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:35:48 CST