Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Synonyms & TableOwner Qualifier

Re: Oracle Synonyms & TableOwner Qualifier

From: Gennaro Napolitano <Gennaro.Napolitano_at_italdata.it>
Date: Fri, 18 Jun 1999 14:23:51 +0200
Message-ID: <376A3A56.883A62C8@italdata.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US