Rather than submit PROC
DATASETS, you can select the libref in SAS Explorer to obtain this
same information. By default, no PUBLIC synonyms are displayed unless
you specify SCHEMA=PUBLIC.
When you specify only
the SCHEMA option, the current schema is always displayed with the
appropriate privileges.
Tables, views, materialized
views, or synonyms on the remote database always are displayed when
you specify the DBLINK= LIBNAME option. If a synonym represents an
object on a remote database that you might not be able to read, you
might receive an Oracle error. An example is a synonym representing
a sequence.
Synonyms, tables, views,
and materialized views in a different schema are also displayed.