16.20 - PASSWORD - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

A password associated with the new user.

You must specify a password.

You cannot specify any other options for the new user until after you specify the PERMANENT and PASSWORD options.

If the user submitting the CREATE USER statement is a member of a profile that specifies values for password control attributes, the password the creator assigns in the CREATE USER statement must comply with the password controls in the creator profile. Applicability of profile-based password control attributes to first-level members of a profile vary. See Effects of Profile-Based Password Controls.

For detailed information on password format requirements and using password controls, see Teradata Vantage™ NewSQL Engine Security Administration, B035-1100.

password
Best security practice suggests that you not assign permanent passwords using CREATE USER requests. Instead, the recommended practice is to assign a temporary password when you create a user, then set the EXPIRE password control attribute to a non-zero value to require users to create private passwords when they first log onto Teradata Database. See the PASSWORD ATTRIBUTES option in CREATE PROFILE.