Usage Note 38204: Using the AUTHDOMAIN= option with SAS/ACCESS® 9.2 engines
 |  |  |  |
The AUTHDOMAIN= option enables you to avoid explicitly specifying a database user ID and password in a SAS program. You define an authorization domain in metadata and define the associated credentials in a metadata repository. Then, you can simply reference the authorization domain in a LIBNAME statement or in the SQL procedure pass-through code, as shown in the following examples:
connect to oracle(authdomain="oracle-authorization-domain" path=oracle-database);
create table foo as
select * from connection to oracle
(select * from employees where jobcode=602);
quit;
The SAS/ACCESS engine accepts the credentials as if the user specified them in the USER= and PASSWORD= options.
The authentication domain and the associated login definition must be stored in a metadata repository and the metadata server must be running in order to resolve the metadata object specification.
When you are running interactively, you can be prompted for connection properties. Prompting occurs when either METASERVER= or METAPORT= are not specified. To avoid the prompt, you can use the following OPTIONS statement before using authdomain= option.
metapass="metadata-password"
metaport=8561
metaprotocol=bridge
metarepository="metadata-repository"
metaserver="server-name";
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Windows 7 Ultimate 32 bit | 9.21 | 9.2 TS2M2 | ||
| Windows 7 Professional 32 bit | 9.21 | 9.2 TS2M2 | ||||
| Windows 7 Professional x64 | 9.21 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium x64 | 9.21 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise x64 | 9.21 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium 32 bit | 9.21 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise 32 bit | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows XP Professional | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows XP 64-bit Edition | 9.21 | 9.2 TS2M2 | ||||
| Microsoft® Windows® for x64 | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | 9.2 TS2M2 | ||||
| z/OS | 9.21 | 9.2 TS2M2 | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21 | 9.2 TS2M2 | ||||
| Windows 7 Ultimate x64 | 9.21 | 9.2 TS2M2 | ||||
| Windows Vista | 9.21 | 9.2 TS2M2 | ||||
| 64-bit Enabled AIX | 9.21 | 9.2 TS2M2 | ||||
| 64-bit Enabled HP-UX | 9.21 | 9.2 TS2M2 | ||||
| 64-bit Enabled Solaris | 9.21 | 9.2 TS2M2 | ||||
| HP-UX IPF | 9.21 | 9.2 TS2M2 | ||||
| Linux | 9.21 | 9.2 TS2M2 | ||||
| Linux for x64 | 9.21 | 9.2 TS2M2 | ||||
| OpenVMS on HP Integrity | 9.21 | 9.2 TS2M2 | ||||
| Solaris for x64 | 9.21 | 9.2 TS2M2 | ||||
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Teradata Data Management ==> Data Sources ==> External Databases ==> Sybase Data Management ==> Data Sources ==> External Databases ==> Oracle Data Management ==> Data Sources ==> External Databases ==> OLEDB Data Management ==> Data Sources ==> External Databases ==> ODBC (Open Database Connectivity) Data Management ==> Data Sources ==> External Databases ==> Netezza Data Management ==> Data Sources ==> External Databases ==> MySQL Data Management ==> Data Sources ==> External Databases ==> MS SQL Server Data Management ==> Data Sources ==> External Databases ==> HP Neoview Data Management ==> Data Sources ==> External Databases ==> DB2 |
| Date Modified: | 2011-02-23 12:17:43 |
| Date Created: | 2009-12-18 00:03:21 |