Re: How create common tables?

From: Mark Bole <makbo_at_pacbell.net>
Date: Sun, 12 Sep 2004 14:27:39 GMT
Message-ID: <v1Z0d.18662$I71.12118@newssvr27.news.prodigy.com>

Michel Cadot wrote:

> "Rosa - Terra" <myrsgsl_at_teleline.es> a écrit dans le message de
> news:Z2l%c.2322129$A6.8084425_at_telenews.teleline.es...
> 

>>I have Oracle 9i enterprise.
>>I've been creating a db and other objects (users, workspaces, roles,
>>profiles,...), but I don' t know how I can create a set of common tables
>>where all the users I've had created can work.
>>
>>At the moment, if I creat a table in a user squeme, and other users want to
>>access to this table, they have to put first the user's name.
>>
>>Example:
>>
>>select * from user.table
>>
>>What I want is to avoid that, and only type:
>>
>>select * from table
>>

[...]

> 
> Have a look at synonyms:
> 
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_72a.htm#2060937
> 

Or, try

ALTER SESSION SET CURRENT_SCHEMA = schema

--Mark Bole Received on Sun Sep 12 2004 - 09:27:39 CDT