Previous Page | Next Page

The LIBNAME Statement for Relational Databases

ACCESS= LIBNAME Option



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

Syntax
Syntax Description
Details

Syntax

ACCESS=READONLY

Syntax Description

READONLY

specifies that you can read but not update tables and views.


Details

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.

Previous Page | Next Page | Top of Page