Re: More than 1 tablespace/user ?

The default tablespace indicates where objects BUILT by the user will be stored...not what objects the user will have access to...

When you grant privs on objects to the user the tablespace the objects are in is not relevant...

terry_stjean_at_my-deja.com wrote:

>We have a software package we bought set up in it's own tablespace. I
>want to create a few add-on tables but keep them in a separate
>tablespace. The question is, when you set up a user, they have a
>default tablespace (which is the package's tablespace). Will they be
>able to see/access the tables I create in the new tablespace. From an
>SQL procedure, do I have to qualify the tables names with the
>tablespace in order to have a procedure use tables in both tablespaces?
>
>Terry
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Jun 29 2000 - 00:00:00 CEST