Oracle Synonyms & TableOwner Qualifier

From: Hank Riehl <hankr_at_skillview.com>
Date: Fri, 18 Jun 1999 07:35:51 -0400
Message-ID: <7kdbeg$7nv@news-central.tiac.net>

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.

Does anyone have any ideas as to how to get around this? Our app uses embedded SQL as well as PowerBuilder Datawindows and the embedded SQL is all written as
unqualified.

Any help here greatly appreciated.

Hank Received on Fri Jun 18 1999 - 06:35:51 CDT