Re: Help! tables in oracle...

Use private synonyms. Create the script to create the synonym and then run it under each user's schema. For the privileges, use ROLES and grant the roles to each user a appropriate.

Alternatively, fully qualified object names can be used (OWNER.OBJECT_NAME) in the SQL.

Or you can (but I don't recommend it) create a public synonym. If you do use public synonyms, be careful to select a unique application prefix for ALL objects in that schema. For example, if you know there will be one and only one marketing database (yeah, right!), you could create public synonyms as MARKETING_<object_name>. Avoid the temptation to use abbreviations.

Have fun!

Steve Long
IT Services, Inc.
804-262-6332

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.
Received on Sun Sep 29 1996 - 00:00:00 CEST