LOGON - Advanced SQL Engine - Teradata Database

Database Utilities

Product

Advanced SQL Engine

Teradata Database

Release Number

17.00

Published

June 2020

Language

English (United States)

Last Update

2020-06-15

dita:mapPath

boh1556732696163.ditamap

dita:ditavalPath

lze1555437562152.ditaval

dita:id

B035-1102

lifecycle

Product Category

Teradata Vantage™

Purpose

The LOGON command establishes a Teradata Database session.

Syntax

Batch mode:

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

Interactive mode:

.LOGON [ tdpid/ ] username [;]

tdpid: Identifier which is associated with a particular Teradata Database.
The default identifier is TDP0.
username: ID of the user on the corresponding Teradata 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.

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.

Usage Notes

The LOGON command is the first command you type in a dul session. The command establishes a session on a Teradata 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 for Teradata Database, as well as on the dump table on the Teradata Database, to perform a load or unload operation.

After you log onto the Teradata Database, dul changes the default database to crashdumps. The crashdumps database is where the Teradata 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 Teradata Database 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 Teradata Database

To log onto a Teradata Database 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 Teradata Database

To log onto a Teradata 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 Database 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 a Teradata Database tdpid02 using the Teradata Database 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.