USER_SYNONYMS

USER_SYNONYMS displays synonyms accessible to the current user.

Table 1 USER_SYNONYMS columns

Name

Type

Description

schema_name

Text

Name of the schema the synonym belongs to.

synonym_name

Text

Synonym name.

table_owner

Text

Owner of the associated object.

table_schema_name

Text

Name of the schema the associated object belongs to.

table_name

Text

Name of the associated object.