The ALTER USER statement changes the name or password of a user account.
Syntax
ALTER USERuser-name < RENAME TOnew-user-name | WITH PASSWORDuser-password >
Remarks
Only the Master user can rename a user. Other users can change their passwords with the WITH PASSWORD clause or by using SET PASSWORD. See SET PASSWORD.
Security must be turned on to perform this statement.
This statement must be used with either the RENAME TO option or the WITH PASSWORD keywords.
New-user-name must be unique in the database.
User-name and user-password must be enclosed in double quotes if they contain spaces or other nonalphanumeric characters. See Granting Privileges to Users and Groups for more information on created users.