AUTHID=

AUTHID=

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

Default value: None

Syntax
Details

Syntax

AUTHID=authorization ID

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 DB2. If AUTHID= is not specified, the table name is not qualified before it is passed to DB2, and DB2 uses your OS/390 user ID as the qualifier. If you specify AUTHID= in a SAS/SHARE LIBNAME, the ID of the active server is the default ID.

AUTHID= is limited to 8 characters. It can also be specified with the SCHEMA alias.

Chapter Contents
Previous
Next
Top of Page