LOGON - Advanced SQL Engine - Teradata Database

Database Utilities

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-27

dita:mapPath

xha1591998860283.ditamap

dita:ditavalPath

xha1591998860283.ditaval

dita:id

B035-1102

lifecycle

Product Category

Teradata Vantage™

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:

Type your logon and press Enter.
For example:
.logon crashdumps
Your logon is repeated, and you are prompted for your password:
```
.logon crashdumps
Password:
```

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.