USER_SYNONYMS view provides information about all synonyms owned by the current user.
|The name of the schema in which the synonym resides.|
|Name of the synonym.|
|User name of the table’s owner on which the synonym is defined.|
|The name of the schema in which the table resides.|
|Name of the table on which the synonym is defined.|
|Name of any associated database link.|