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™ - Advanced SQL Engine 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:
|
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. |