In our project, universe is already built on Private synonyms. But BO Admin is not ready to migrate the universe to Prod since they wanted to build the universe on Public synonyms but not private.
Is there any impact on the current universe if DBA changes private to public synonyms. I mean, do we need to parse each and every table, objects in the universe after DBA changes? as we have hundreds of tables using in universe.
You will have a problem if the private synonyms are referenced by owner in the universe. That is, “schemaowner.tablename”. If you have not set an owner for the tables, then you should be all set.
Note that when you use public synonyms, you will not be able to use “Refresh structure” unless you temporarily plug in the actual schema of the physical table as the table owner. However, your objects should still parse and queries should still work.
(BOB member since 2002-08-29)