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

This function is an extension to SQL grammar as documented in the Microsoft ODBC Programmer's Reference.

Only the Master user can perform this statement. See SET PASSWORD for how other users can change their own passwords.

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 password must be enclosed in double quotes if they contain spaces or other non-alphanumeric characters. See Users and Groups for more information on created users.

---

Note
For information on password restrictions, see Table 1-1:Identifier Restrictions by Identifier Type and 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 Permission Tasks in Pervasive PSQL 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 non-alphanumeric 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).

CREATE USER pgranger WITH PASSWORD "Nonalfa$" 

The password for user account pgranger is changed to Nonalfa$ (case-sensitive) containing non-alphanumeric characters.

See Also

ALTER (rename)

CREATE GROUP

CREATE USER

DROP USER

GRANT