SAS/ACCESS Interface to Teradata does not support the use of LDAP authentication to log on to the Teradata database. However, that support is now available via this hot fix.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Syntax and Usage

USER=<'>Teradata-user-name<'> | <">ldapid@LDAP<"> | <">ldapid@LDAPrealm-name<">  

If the name contains blanks or national characters, enclose it in quotation marks. For LDAP authentication with either a null value or single realm, append only the @LDAP token to the Teradata user name. In this case, no realm name is needed. If you append one, the LDAP authentication server ignores it and authentication proceeds. However, if multiple realms exist, you must also append the realm name to the @LDAP token. In this case, an LDAP server must already be configured to accept authentication requests from the Teradata server.

The PASSWORD= option is a required connection option that specifies a Teradata password. Syntax for the PASSWORD= option is as follows:

PASSWORD=<'>Teradata-password<'>

The password that you specify must be correct for your USER= value. If you do not want to enter your Teradata password in clear text on this statement, you can encode it using the PWENCODE procedure. For details on PROC PWENCODE, see the Base SAS 9.1.3 Procedures Guide in SAS OnlineDoc 9.1.3.

For LDAP authentication, you must include the LDAP authentication password that corresponds to your LDAP user name.

LDAP Authentication Examples

LDAP example with a null or single-realm configuration:

   libname x teradata user="johndoe@LDAP" password="johndoeworld"

LDAP example showing a connection to a specific realm in a multi-realm configuration:

   libname x teradata user="johndoe@LDAPjsrealm1" password="johndoeworld"

LDAP example with a null or single-realm configuration, with a password that has an embedded at (@) symbol (PASSWORD="JOHNDOE@WORLD"). Note that the embedded @ must be preceded by the backslash (\).

 
libname x teradata user="johndoe@LDAP" password="johndoe\@world"

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: