Lets you qualify the specified table with an authorization ID, user ID, or group ID.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Alias: | SCHEMA= |
| Default: | LIBNAME option value |
| Data source: | DB2 under z/OS |
| See: | AUTHID= LIBNAME option, DBCONINIT= LIBNAME option |
Table of Contents
If you specify a value for the AUTHID= option, the table name is qualified as authid.tablename before any SQL code is passed to the DBMS. If you do not specify AUTHID=, the table name is not qualified before being passed to the DBMS and the DBMS uses your user ID as the qualifier. If you specify AUTHID= in a SAS/SHARE LIBNAME statement, the ID of the active server is the default ID.
If
you specify DBCONINIT="SET CURRENT SQLID='user-ID'",
then any value that is specified for AUTHID= or SCHEMA= is ignored.