Re: reading another user's tablespace

A copy of this was sent to quinn coldiron <qcoldiro_at_thetoolhouse.com> (if that email address didn't require changing) On Tue, 03 Aug 1999 11:14:33 -0500, you 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

tablespaces are containers for objects -- you don't grant access to them to read the objects in them.

user B needs to grant SELECT on the tables he owns to user A. We grant access to objects, not tablespaces themselves...

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 03 1999 - 11:52:20 CDT