Oracle Database Discussions

Hi,

Our DBA (?) has a rule here that all tables must have public synonym.

Is this a industry standard practice?

I am not a DBA but in recent assignment i need to setup a schema and i have been to told to create public synonums for each table (regardless if they will be used across schemas or not). I was under the impression that you usually create a private synonyms for each table and when you need to access table (or object) in another schema/user, you create private synonym in that new schema/user. is that a correct procedure?

One last point, how would you handle same table name (like address table) in multiple schemas if you have standard practice of creating public synonyms for each tables? that would be problem isn't it?

I just want to find out how DBAs are handling synonyms creating procedure and rules.

Thank you in advance

-R