Previous Page | Next Page

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.


See Also

To assign this option to a group of relational DBMS tables or views, see the AUTHID=  LIBNAME Option.

Previous Page | Next Page | Top of Page