Special welcome gift. Get 50% off your first courses with code “AS50”. Find out more!

HomeInterviewExplain the types of synonyms.
course 5

Explain the types of synonyms.

There are two types of synonyms: 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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

Categories

ads sidebar 1

You May Also Like

Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...