SYS.ALL_SYNONYMS

The ALL_SYNONYMS view describes the synonyms accessible to the current user. These criteria determine the list of synonyms that ALL_SYNONYMS shows:

• All private synonyms owned by the logged-in user, even if the base object is not accessible to the user.

• All public synonyms, even if the base object is not accessible to the user.

• All private synonyms owned by a different user, where the base object pointed to by the synonym or by nested synonyms is known to be accessible because of a grant to the logged-in user.

The base object can be a table, view, synonym, sequence, PL/SQL stored procedure, PL/SQL function, PL/SQL package, materialized view or cache group.

Related views

• SYS.DBA_SYNONYMS describes all synonyms in the database.

• SYS.USER_SYNONYMS describes the synonyms owned by the current user. This view does not display the OWNER column.

Columns