For this option to work,
you must have appropriate privileges to the schema that is specified.
If you do not specify
this option, you connect to the default schema for your DBMS.
The values for SCHEMA=
are usually case sensitive, so be careful when you specify this option.
The default is
which uses the database user's default schema. When the user's default
scheme is the user name, the user name is used instead. An example
is when SQLTables is called to obtain a table listing using PROC DATASETS
or SAS Explorer.
default is the LIBNAME setting. If PRESERVE_TAB_NAMES=NO, SAS converts
the SCHEMA= value to uppercase because all values in the Oracle data
dictionary are converted to uppercase unless quoted.
cannot use the SCHEMA= option when you use UPDATE_LOCK_TYPE=PAGE to
update a table.
default is the LIBNAME setting. If you omit this option, a libref
points to your default Teradata database, which often has the same
name as your user name. You can use this option to point to a different
database. This option lets you view or modify a different user's DBMS
tables or views if you have the required Teradata privileges. (For
example, to read another user's tables, you must have the Teradata
privilege SELECT for that user's tables.) For more information about
changing the default database, see the DATABASE statement in your