PASSWORD - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

New password for the specified user.

All users have the MODIFY USER privilege on their own user definition. This enables users to:

  • Create a private password at the system prompt after attempting a first logon with a temporary password. For details, see the explanation of the PASSWORD keyword in CREATE USER.
  • Create a new password when their existing user password expires.
password
Passwords must follow required formatting rules. See Teradata Vantage™ - Analytics Database Security Administration, B035-1100.
FOR USER
[Optional] Removes the existing password for the specified user immediately and sets the password expiration date to zero, depending on the value of the Expire option in the profile assigned to the user.
If user is not assigned a profile or if the Expire option in the assigned profile is not set, then the expiration date is set to the value of the Expire Password column specified in DBC.SysSecDefaults as shown in the following table.
  • If the Expire value in the user profile or the value for ExpirePassword inDBC.SysSecDefaults is 0, then the current password expires immediately and the new temporary password becomes valid indefinitely.
    This is a potential security breach. You must ensure that it does not happen.
  • If the Expire value in the user profile or the value for ExpirePassword inDBC.SysSecDefaults is > 0, then the current password expires immediately and the new temporary password becomes valid.

    The value for ExpirePassword is reset to 0.

    The new temporary password expires at first logon, at which time the user must create a new, permanent password.

The password attribute settings in a user profile override the corresponding system-level password settings.
For more information about DBC.SysSecDefaults and ExpirePassword, see Teradata Vantage™ - Analytics Database Security Administration, B035-1100 and Teradata Vantage™ - Data Dictionary, B035-1092. For more information about profiles, see CREATE ROLE.