Alters user settings.
ALTER USER user-name [ IDENTIFIED BY password ]
The name of the user.
The password for the user.
If you use this statement in a procedure, do not specify the password (IDENTIFIED BY clause) as a string literal because the definition of the procedure is visible in the SYSPROCEDURE system view. For security purposes, specify the password using a variable that is declared outside of the procedure definition.
User IDs cannot:
Passwords are case-sensitive and they cannot:
The following alters a user named SQLTester. The password is set to "welcome".
ALTER USER SQLTester IDENTIFIED BY welcome