Re: Question on object names

Just declare a public synonym for the shared object.

By example:

  create table TAB1 ...

  Grant select on TAB1 to anotherUser_1;   Grant select on TAB1 to anotherUser_2;    ...
   Create public synonym TAB1 for TAB1

   That's all.

  It works for any object type (Tabl, procedure, view, etc ...)

  Yann.

Craig Despres a écrit :

> We have just started development using Oracle (coming from an Informix shop)
> and I have a question on the how to access objects created on the database.
>
> When a table is created for a person's schema (owner.tablename), is there
> "GRANT" permissions, or another way to allow other users/programs to access
> this table without putting the "owner" in front of the table name? I would
> also like to know how to do the same things for other database objects,
> e.g - procedures, packages, synonyms, views, etc.
>
> Any help would be greatly appreciated.
>
> --
> Craig Despres
> Synergy Solutions Inc.
Received on Wed Sep 15 1999 - 03:01:45 CDT