Allows qualified table names with an authorization ID, a user ID, or a group ID.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Access |
| Alias: | SCHEMA= |
| Default: | none |
| Data source: | DB2 under z/OS |
| See: | AUTHID= data set option, DBCONINIT= LIBNAME option |
Table of Contents
When you specify the AUTHID= option, every table that is referenced by the libref is qualified as authid.tablename before any SQL code is passed to the DBMS. If you do not specify a value for AUTHID=, the table name is not qualified before it is passed to the DBMS. After the DBMS receives the table name, it automatically qualifies it with your user ID. You can override the LIBNAME AUTHID= option by using the AUTHID= data set option. This option is not validated until you access a table.
If
you specify DBCONINIT="SET CURRENT SQLID='user-ID'",
then any value that is specified for AUTHID= is ignored.