AUTHID= Data Set Option

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)
Alias: SCHEMA=
Default: LIBNAME setting
Data source: DB2 under z/OS
See: AUTHID= LIBNAME option

Syntax

AUTHID=authorization-ID

Syntax Description

authorization-ID
limited to eight characters.

Details

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.