16.10 - Example: TD2 Logon - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K
.logmech TD2
.logon  tdpid/username,password[,”account”]

where:

Syntax Element Description
TD2 The TD2 mechanism (the default) specifies Teradata Database authentication. The .logmech statement is optional unless another mechanism is set as the default.
tdpid The tdpid identifies the logon connection.

If logging on directly to a database system, use one of the following:

  • Database system tdpid
  • Database host group tdpid (required if using host groups)

If logging on through Unity, use one of the following:

  • Unity server tdpid
  • Unity host group tdpid (required if the Unity server is set up for host groups)
username The name of a user defined in the database.
password The password for the database username.
“account” Optional account string, which must be enclosed in double quotation marks.