Re: reading another user's tablespace

You will need to grant select on 'schemaname.tablename' to user a

so

grant select on usera.table1 to userb;

Or
set up a public synonym for userB's table like; create public synonym table1 for usera.table1; grant select on table1 for useb;

The permissions are for tables not tablespaces...

Hope it helps..

quinn coldiron <qcoldiro_at_thetoolhouse.com> wrote:

>I have user A with default tablespace A and user B with default
>tablespace B. How can I let user A read the data in the tables in
>tablespace B?
>
>System: Oracle 8.0.5, Unix
>
>Quinn

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Aug 03 1999 - 11:26:17 CDT