The USER_SYNONYMS view provides the information about all synonyms owned by the current user.
|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.|