Create Temporary Passwords | Teradata Vantage - 17.00 - 17.05 - Creating Temporary Passwords for First Login - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

Vantage requires you to associate a username with a password when you first create a user. You must specify a password, even if temporary. Otherwise the Parser rejects the statement as incomplete.

The security administrator can prompt users for a new password upon first login if:
  • At the time of installing a new system, the administrator has created generic passwords for all users and wants them to choose their own passwords.
  • New password requirements must be enforced. For example, if the security administrator wants to require mixed case and wants all users to change their passwords.
Teradata password rules do not apply to external authentication. For more information, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.

To use SQL, see “Passwords” under “CREATE USER” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.