16.10 - Using BTEQ to Verify Directory User Mapping - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
Language
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
.quit
To test maps to multiple Teradata 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.