Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Synonyms & TableOwner Qualifier
Hank Riehl wrote:
> Our app (currently at PowerBuilder 6.5) has been deployed on a variety of
> backends,
> including SQL Svr, Syabse & Oracle.
>
> For Oracle sites, we create public synonyms for every table name (35 or so
> tables) to eliminate the need for qualified reference; i.e.
> Create public synonym dept for tableowner.dept
> so that any user may simply run sql against table dept without need to
> reference tableowner.
>
> A new customer has indicated that these synonyms are unacceptable to them.
> They are afraid of naming conflicts with other tables in other schemas in
> the instance.
>
Why don't create a dedicated Oracle istance for your application?
Ciao Gennaro Received on Fri Jun 18 1999 - 07:23:51 CDT