BTEQ for Verifying Directory User Mapping | Teradata Vantage - Using BTEQ to Verify Directory User Mapping - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

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
.quit
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.