Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.46 USER_SYNONYMS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.46 USER_SYNONYMS

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

Name

Type

Description

owner

TEXT

User name of the synonym’s owner.

synonym_name

TEXT

Name of the synonym.

object_owner

TEXT

User name of the table’s owner on which the synonym is defined.

object_name

TEXT

Name of the table on which the synonym is defined.

status

VARCHAR2(5)

Included for compatibility only; always set to VALID.

db_link

TEXT

Name of any associated database link.

Previous PageTable Of ContentsNext Page