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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How create common tables?

Re: How create common tables?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 7 Sep 2004 18:47:58 +0200
Message-ID: <413de619$0$28606$636a15ce@news.free.fr>

"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
>
> And that, for an user group defined by me.
>
> In this form, all the users could work in the same tables.
>
> Sorry for my speech.
>
>
>
>
> --
> Rosa Mª Sánchez Garrido
>
>

Have a look at synonyms:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_72a.htm#2060937

-- 
Regards
Michel Cadot
Received on Tue Sep 07 2004 - 11:47:58 CDT

Original text of this message

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