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.
- Passwords must follow required formatting rules. See “Managing Database Passwords” in Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.
- FOR USER
- Legacy keywords that are no longer used.