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

Home -> Community -> Usenet -> c.d.o.server -> Corporate Wide Public Synonyms

Corporate Wide Public Synonyms

From: <linuxgeek_00_at_yahoo.com>
Date: 10 Feb 2005 12:53:58 -0800
Message-ID: <1108068838.968042.219230@f14g2000cwb.googlegroups.com>


My company wants to implement a corportate wide public synonym model for our oracle 9i database. Meaning that every table in every schema would have a public synonym created against it. Personally I think this is a bad idea. However I need to develop a convincing arguement to change this policy that has been suggested by our "DBA's".

One issue is that I'm aware of is that all table names must be unique across all schemas. Please let me know other reasons why it is a bad idea to create public synonyms for every table in every schema.

Thanks Received on Thu Feb 10 2005 - 14:53:58 CST

Original text of this message

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