Developer Reference : Data Access Methods : SQL Engine Reference : SQL Syntax Reference : ALTER USER
 
ALTER USER
The ALTER USER statement changes the name or password of a user account.
Syntax
ALTER USER user-name < RENAME TO new-user-name | WITH PASSWORD user-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.
Note For information on password restrictions, see Table 1, Identifier Restrictions by Identifier Type, and the topic Database Security in Advanced Operations Guide.
For further general information about users and groups, see Master User and Users and Groups in Advanced Operations Guide and Assigning Permissions Tasks in Zen User’s Guide.
Examples
The following examples show how to rename a user account.
ALTER USER pgranger RENAME TO grangerp
The name of the account pgranger is changed to grangerp.
ALTER USER pgranger RENAME TO "polly granger"
The name of the account pgranger is changed to polly granger containing nonalphanumeric characters.
============ 
The following examples show how to change the password for a user account.
ALTER USER pgranger WITH PASSWORD Prvsve1
The password for user account pgranger is changed to Prvsve1 (case-sensitive).
ALTER USER pgranger WITH PASSWORD "Nonalfa$"
The password for user account pgranger is changed to Nonalfa$ (case-sensitive) containing nonalphanumeric characters.
See Also
ALTER (rename)
CREATE GROUP
CREATE USER
DROP USER
GRANT
SET PASSWORD