There are two types of Synonyms which are- Public and Private.
A public synonym isn’t part of any schema. A public synonym is one that can be used by any database user.
A private synonym does belong to a specific schema. In other words, when only the owner can access it, it is called a private synonym.
If you want to become a professional MS SQL Server DBA expert. Learn and master this technology by enrolling in Intellipaat’s MS SQL Server DBA Course in Hyderabad.
