17.10 - LOGON - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The LOGON command establishes a Vantage session.

This describes the standard TD 2 (Teradata authentication) logon format. For more information about other logon formats and types of authentication see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.

Batch Mode Syntax

.LOGON [ tdpid/ ] username, password [, 'acctid' ] [;]

Interactive Mode Syntax

.LOGON [ tdpid/ ] username [;]

Syntax Elements

tdpid
Identifier which is associated with a particular database.

The default identifier is TDP0.

username
ID of the user on the corresponding database.

The maximum length of username is 30 characters.

password
Password associated with the username.

The maximum length of a password is 30 characters.

In interactive mode, the password is accepted on the next line in a protected area.
acctid
Account identifier associated with the username. The acctid can contain up to 30 characters.

Each doubled apostrophe, if any, counts as one character of the 30 characters.

Usage Notes

  • The LOGON command is the first command you type in a dul session. The command establishes a session on a database and identifies you and the account that is charged for system resources used during a dul operation. To ensure system security, the password is not displayed when dul is used interactively.
  • You must have CREATE, DROP, and SELECT privileges on DBC.SW_EVENT_LOG, as well as on the dump table on the database, to perform a load or unload operation.
  • After you log on to Vantage, dul changes the default database to crashdumps. The crashdumps database is where the database initially saves a dump. However, you can change the default database with the DATABASE command.
  • For additional information on granting privileges, see Teradata Vantage™ - Database Administration, B035-1093. For more information on the crashdumps database, see DATABASE.
  • Logon with Teradata Wallet

    Teradata Wallet is a secure store for client credentials. It stores passwords for Vantage authentication, which can automatically be retrieved at run time and submitted to the database. Teradata Wallet must be configured with usernames and passwords before it can be used for logons using DUL. For more information on configuring Teradata Wallet, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.

Example: Batch Mode Logon to Vantage

To log onto a dDatabase with a tdpid of TDP0, a username of Admin, and a password of abc, type the following:

LOGON TDP0/Admin,abc ;

The following appears:

*** Logon successfully completed.
*** Teradata Database Release is 14.00.00
*** Teradata Database Version is 14.00.00
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.
*** Changing current database to crashdumps.
*** New default database accepted.
*** File Compression Enabled.
*** MultiFile option ON.
*** NoSpool option OFF.

Example: Interactive Mode Logon to Vantage

To log onto a database with a tpid of crashdumps, a username of crashdumps, and a password of crashdumps, type the following:

  1. Type your logon and press Enter.

    For example:

    .logon crashdumps

    Your logon is repeated, and you are prompted for your password:

    .logon crashdumps
    Password:
  2. Type your password and press Enter.

    For example:

    crashdumps

    Your password will not appear on screen.

    The following appears:

    *** Logon successfully completed.
    *** Teradata Database Release is 14.00.00
    *** Teradata Database Version is 14.00.00
    *** Transaction Semantics are BTET.
    *** Character Set Name is 'ASCII'.
    *** Changing current database to crashdumps.
    *** New default database accepted.
    *** File Compression Enabled.
    *** MultiFile option ON.
    *** NoSpool option OFF.
    Dump Unload/Load - Enter your command:

Example: Batch Mode logon using Teradata Wallet

To log on to Teradata system tdpid01, using the username and password string created by Teradata Wallet, enter the following:

logon tdpid01/$tdwallet(dultuser),

The following appears:

 *** Logon successfully completed.
 *** Teradata Database Release is 14.00.00.00
 *** Teradata Database Version is 14.00.00.00
 *** Transaction Semantics are BTET.
 *** Character Set Name is 'ASCII'.
 *** Changing current database to crashdumps.
 *** New default database accepted.
 *** File Compression Enabled.
 *** MultiFile option OFF.
 *** NoSpool option OFF.

Example: Interactive Mode logon using Teradata Wallet

To log on to Teradata system tdpid02 using the Vantage username and password for Teradata Wallet user dultuser, type the following at the interactive prompt:

logon tdpid02/$tdwallet(dultuser);

At the Password prompt enter:

$tdwallet(dultuser)

The following appears:

 *** Logon successfully completed.
 *** Teradata Database Release is 14.00.00.00
 *** Teradata Database Version is 14.00.00.00
 *** Transaction Semantics are BTET.
 *** Character Set Name is 'ASCII'.
 *** Changing current database to crashdumps.
 *** New default database accepted.
 *** File Compression Enabled.
 *** MultiFile option ON.
 *** NoSpool option OFF.