Data Set Options for Relational Databases |
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
|
-
authorization-ID
-
is limited to eight characters.
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.
To assign this option to a group of
relational
DBMS tables or views, see the AUTHID= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.