Command-Line Logon - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qia1556235689628.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢
Users provide the following information when logging on from a workstation-attached client:
  • .logmech: Specifies the name of the security mechanism that defines the method by which the user will be authenticated and authorized. If a mechanism is not specified, the logon proceeds using the designated default mechanism.
  • .logdata: Used only for external authentication. Specifies the username and password, and optionally names an individual username, profile, or role where the logon user has access to multiple user identities, profiles, or roles.
  • .logon: Must be used for Teradata Database authentication. May be used for external authentication except when the logon requires specification of user=, profile=, or realm= to differentiate among multiple user identities, profiles, or realms.

    For either authentication type, .logon specifies the tdpid, username, password, and optional account string information.

    The format required for the username and password information varies depending on the user is sign-on method.

For more information on command-line logons, see Teradata Vantageā„¢ - Advanced SQL Engine Security Administration, B035-1100.