ALTER USER user-name [ IDENTIFIED BY password ]

User IDs and passwords cannot:

• begin with white space, single quotes, or double quotes
• end with white space
• contain semicolons

A password can be either a valid identifier, or a string (maximum 255 bytes) placed in single quotes. Passwords are case sensitive. It is recommended that the password be composed of 7-bit ASCII characters, as other characters may not work correctly if the database server cannot convert them from the client's character set to UTF-8.

Any user can change their own password. All other changes require DBA authority.

None.

• CREATE USER statement [UltraLite]
• DROP USER statement [UltraLite]

The following alters a user named SQLTester. The password is set to "welcome".

ALTER USER SQLTester IDENTIFIED BY welcome;