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

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.