VIEW: SYS.USER_SYNONYMS

Source

View Text - Preformatted

select SYNONYM_NAME, TABLE_OWNER, TABLE_NAME, DB_LINK,
          ORIGIN_CON_ID
from NO_ROOT_SW_FOR_LOCAL(INT$DBA_SYNONYMS)
where OWNER=SYS_CONTEXT('USERENV', 'CURRENT_USER')

View Text - HTML Formatted

SELECT SYNONYM_NAME
, TABLE_OWNER
, TABLE_NAME
, DB_LINK
, ORIGIN_CON_ID FROM NO_ROOT_SW_FOR_LOCAL(INT$DBA_SYNONYMS) WHERE OWNER=SYS_CONTEXT('USERENV'
, 'CURRENT_USER')