Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Alters user settings.
This statement is not supported by UltraLite Java edition databases.
ALTER USER user-name [ IDENTIFIED BY password ]
The name of the user.
IDENTIFIED BY clause
The password for the user.
User IDs cannot:
Passwords are case-sensitive and they cannot:
Any user can change their own password. All other changes require DBA authority.
The following alters a user named SQLTester. The password is set to "welcome".
ALTER USER SQLTester IDENTIFIED BY welcome;