Data Set Options for Relational Databases

AUTHID= Data Set Option

Lets you qualify the specified table with an authorization ID, user ID, or group ID.

Alias:	SCHEMA=
Default value:	LIBNAME setting
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	DB2 under z/OS

Syntax
Syntax Description
Details
See Also

Syntax

AUTHID=authorization-ID

Syntax Description

authorization-ID: is 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 AUTHID= is not specified, the table name is not qualified before it is 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.