The LIBNAME Statement for Relational Databases |
Determines
the access level with which a libref connection is
opened.
Default value: |
none
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
Aster nCluster, DB2 under
UNIX and PC Hosts, DB2 under z/OS,
Greenplum, HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC,
OLE DB, Oracle, Sybase, Sybase IQ, Teradata
|
-
READONLY
-
specifies that you can read but not update
tables and views.
Using this option prevents writing to
the DBMS. If this option is omitted, you can read and update tables and views
if you have the necessary DBMS privileges.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.