Database Authentication - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

When a user accessing a database is authenticated, values for the security attributes should be specified as follows:

Make sure that any UserName specified in a Teradata PT job script has the privileges necessary to carry out all operations covered by the logon.
Security Attribute Description Strategy
UserName The name of the user being authenticated for access to the database Required.

Specify a database user name and password.

For information about creating users and assigning passwords, see Teradata Vantage™ - Analytics Database Security Administration, B035-1100.

UserPassword The password associated with the UserName
TdpId Identifies the connection to a database Optional.

If you do not specify a TdpId, the database system will use the default TdpId, as defined in the Teradata Client clispb.dat.

To specify a TdpId, do the following:
  • For mainframe-attached clients, this value is the identity of the Teradata Director Program through which Teradata PT connects to the database. For example:
    TDP6
  • For workstation-attached clients this value is the name of the interface to the database system, or logical host group. For example:
    cs4400S3
LogonMech The security mechanism used to authenticate the user.

TD2 is required for all database authentication.

Optional, depending on security setup.

TD 2 is the default mechanism and the database system will automatically defer to it unless the default has been set to another mechanism or TD 2 has been disabled.

LogonMechData Data required only by external authentication mechanisms to complete the logon. LogonMechData is not required for database authentication, and is ignored.