Oracle Best Practices Discussion Pros/Cons of using Synonyms
yakub21Nov 4 2009 — edited Nov 6 2009Please share your experience given the Pros/Cons of Developing Enterprise Database Applications using public and private Synonyms.
My recommendation to developers on my team is to avoid using Public Synonyms in their code and instead Fully Qualify the database object by schema owner.
Pros: When you drop a schema, you do not drop the public synonyms that they created. Therefore if you have to use synonym, make it private and not public.
Please share your experience!