Re: Help! tables in oracle...

In <32484451.6395_at_po.cwru.edu>, Somil Mittal <skm3_at_po.cwru.edu> writes:
>Hi Guys,
>
> I am new to Orcale 7 and stuck. Here's my problem:
>
> 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?
>
>
>Thanks in Advance,
>
>
>Somil Mittal
>
>ps. I would really appreciate help on this. Am desparate.

Create a public synonym for the table.

    \                                                                                /
   o/\__                                                                        __/\o
  <\__,\   "Views represented here are mine and not my employers"      /,__/>
   ">  . |   Rich Bernat                                                       | . <"
    `    .-\                                                                   /-.  `
        .   |                                                                   |   .