17.10 - Configuring LDAP for Directory Authentication and Authorization - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

To configure LDAP for authentication and authorization requires the following:

Because the user is authorized by the directory the directory username does not need an equivalent database username, as is the case for an authentication-only implementation
  • Make sure that the LDAP MechanismEnabled property is set to “yes” (the default).
  • Configure the LdapServerName property. See LdapServerName.
  • Optionally configure directory user identification options to speed directory searches for user authorization mapping. See Optimizing Directory Searches.

The procedure for configuring mechanism property values in the TdgssUserConfigFile.xml is shown in Making Changes to TdgssUserConfigFile.xml on Database Nodes.

You must also map directory users to other directory objects to define user database privileges in the directory. See Provisioning Directory Users with Teradata Schema Extensions or Using Native Directory Schema to Provision Directory Users.