Re: Help! tables in oracle...

create a public synonym for the table,
or
the users can prefix the queries, username.tablename in the FROM clauses.

hope it helps
Randy :)

Somil Mittal (skm3_at_po.cwru.edu) wrote:
: 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.

--
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I