bSynonym

Synonyms are supported by a new field in the TBLBaseDesc structure called bSynonym. The field bSynonym is a BOOL16, which is set to TRUE if the object is a synonym.

The BDE configuration option LIST SYNONYMS can be found in the Registry's DB OPEN section for Oracle DRIVERS and DATABASES. See BDE Administrator Help).

The value of LIST SYNONYMS determines whether or not to include synonyms in the schema table returned from DbiOpenTableList and DbiOpenFileList, as shown in the following table.

Value	Meaning
NONE	Do not include any synonyms (Default)
PRIVATE	Only include private synonyms
ALL	Include both private and public synonyms

Oracle: Oracle has PUBLIC synonyms that show up in the table list when the value of LIST SYNONYMS = ALL. However, to open a PUBLIC synonym, the user must also have SELECT privileges on the base object of the synonym. If the user does not have SELECT privileges and tries to open the PUBLIC SYNONYM, Oracle returns the error "Table or view does not exist".

Oracle has PUBLIC synonyms to a set of dynamic performance tables. Even though these are PUBLIC synonyms, they are accessible only to the DBA user SYS, by default (other users can be granted privileges). These synonym names are in the format, V$... (that is, V$DATABASE, V$ACCESS, and so on).