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.
For detailed information on password format requirements and using password controls, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.
- 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 Vantage. See the PASSWORD ATTRIBUTES option in CREATE PROFILE.