Re: Help! tables in oracle...
From: John Verhoeven <johnv_at_acix.DIALix.oz.au>
Date: 1996/09/28
Message-ID: <johnv.0a4b_at_acix.DIALix.oz.au>#1/1
Date: 1996/09/28
Message-ID: <johnv.0a4b_at_acix.DIALix.oz.au>#1/1
In article dated 25 Sep 1996 18:35:06 GMT, Rich Bernat (rber_at_chevron.com) wrote:
> In <32484451.6395_at_po.cwru.edu>, Somil Mittal <skm3_at_po.cwru.edu> writes:
> >Hi Guys,
> > I have to create a table which will be used by around 20 users who
> >shall run their SQL queries on it. If I use the CREATE TABLE command,
> >I can create the table only for one schema, thus the other users can't
> >see the table. How can I create a table such that all users can run
> >their SQL queries on them?
>
> Create a public synonym for the table.
You would also need to grant privileges on the object to users or well or do you propose to grant privileges on the object to public?
--
_--_|\ John Verhoeven Unix / Database Administrator Westrail
/ \ johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
v "Smile! things could be worse... So I did... and they were..."
Received on Sat Sep 28 1996 - 00:00:00 CEST