Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Corporate Wide Public Synonyms
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