BTEQ for Verifying Directory User Mapping | Teradata Vantage - 17.10 - Using BTEQ to Verify Directory User Mapping - 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 test the new directory configuration using BTEQ, set up a script that contains a valid directory logon, for example:

.logmech ldap
.logon tdpid/dirusername,dirpassword
To test maps to multiple Vantage users or profiles, also include the associated .logdata syntax.

See Logging on Using LDAP Authentication and Authorization for logon format options.

If all directory integration tasks are complete and correct, a properly formatted logon should succeed. If the logon fails, one of the following may be the cause of the failure:
  • One or more of the logon parameters are not in the directory information tree.
  • One or more of the logon parameters are not mapped to the directory user.
  • The directory failed to authenticate the authcid and password.
  • The LDAP mechanism configuration is not correct.