Re: Read Only user without default tablespace

jim.griffiths_at_the-griffiths.com wrote:
> I have a read only user that was created on an Oracle 10.g database
> that needs access to 9 different tablespaces.
>
> When I connect with sqlplus I cannot find an option to select the
> tablespace that I want to connect to for that session. Is it possible
> to do that?
>
> Would there be a way to define a tnsnames.ora entry that would connect
> me to the appropriate tablespace?

Study Oracle' security and privileges architecture basics.

Object privileges do not include tablespaces. Grant on a table-by-table or view-by-view basis: At the column level if you wish.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org