Google News
logo
Oracle - Interview Questions
Explain the types of Synonyms?
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.
Advertisement