The LIBNAME Statement for Relational Databases AUTHID= LIBNAME Option 69
Note: When a like-named option is specified in both the LIBNAME statement and
after a data set name, SAS uses the value that is specified on the data set name.
ACCESS= LIBNAME Option
Determines the access level with which a libref connection is opened
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value:
none
Syntax
ACCESS=READONLY
Syntax Description
READONLY
specifies that tables and views can be read but not updated.
Details
Using this option prevents writing to the DBMS. If this option is omitted, tables and
views can be read and updated if you have the necessary DBMS privileges.
AUTHID= LIBNAME Option
Enables you to qualify your table names with an authorization ID, user ID, or group ID
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: DB2 OS/390
Default value:
none
Syntax
AUTHID=authid
Syntax Description
authid
cannot exceed 8 characters.
