17.10 - PASSWORD - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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™ - Advanced SQL Engine 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™ - Advanced SQL Engine Security Administration, B035-1100 and Teradata Vantage™ - Data Dictionary, B035-1092. For more information about profiles, see CREATE ROLE.