Novice Multi-User Help

From: Aaron Sayer <aaron_at_solsup.com.au>
Date: Fri, 22 Jan 1999 18:35:51 +1100
Message-ID: <7899lr$lhb$1@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 - 01:35:51 CST