The USER_SYNONYMS view provides the information about all synonyms owned by the current user.

Parameter Type Description
schema_name TEXT The name of the schema to which the synonym belongs.
synonym_name TEXT The name of the synonym.
table_owner TEXT The username of the owner of the table on which the synonym is defined.
table_schema_name TEXT The name of the schema to which the table belongs.
table_name TEXT The name of the table on which the synonym is defined.
db_link TEXT The name of any associated database link.