Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Read Only user without default tablespace

Read Only user without default tablespace

From: <jim.griffiths_at_the-griffiths.com>
Date: Thu, 25 Oct 2007 13:36:40 -0700
Message-ID: <1193344600.005445.307210@19g2000hsx.googlegroups.com> 





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?
Received on Thu Oct 25 2007 - 15:36:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US