Re: Novice Multi-User Help

It doesn't matter who created the tablespace, what is important is who owns the table in this case User1.

The general solution to your problem is to grant permissions and create synonyms, the simplest solution to your problem would be -

While connected as user1

Grant all on Table1 to User2;
Create pubic synonym Table1 for User1.Table1;

Connect as User2 and you can now

Select * from Table1;

as required. The same method will work for other objects e.g. Procedures, functions, packages.

(Note that Procedures, Functions and Packages are not stored in specific tablespaces, they are stored in the system catalogue - which happens to reside in the SYSTEM tablespace).

Aaron Sayer <aaron_at_solsup.com.au> wrote in message news:7899lr$lhb$1_at_perki.connect.com.au...
>Hi,
> We are using Oracle Web Server and have created procedures in a created
>tablespace. Now we want to add anther user that can access the
>procedures/tables by default without aliasing.
>EG:
>Created Tablespace1/tables/procedures under User1
>Created User2
>Now want to access tables/procs from Tablespace1 as User2 with out doing
the
>following:
>Select * from Tablespace1.Table1
>
>Would like to do this
>Select * from Table1
>
>Table1 is located in Tablespace1 created by User1.
>
>Hope that makes sense.
>Please mail me.
>Thanks in advance
>Aaron.
>aaron_at_solsup.com.au
>
>
>
>
Received on Fri Jan 22 1999 - 02:49:06 CST