Это из хелпа
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.
ALTER GROUP
The ALTER GROUP statement adds or removes a user account from a group.
Syntax
ALTER GROUP group-name
<ADD USER user-name [ , user-name ]... | DROP USER user-name [ , user-name ]...>
Remarks
This function is an extension to SQL grammar as documented in the Microsoft ODBC Programmer's Reference.
Only the Master user can execute this statement.
This statement must be used with one of the available keywords.
A user account cannot be added to a group if the group is not already created in the database. To create users and add them to groups simultaneously, see GRANT .
Dropping a user account from a group does not remove the group from the database.
User accounts cannot belong to multiple groups simultaneously. A user account cannot be added to a group if it is currently a member of another group. Such a user account must first be dropped from its current group and then added to another group.
A user name must be enclosed in double quotes if it contains spaces or other non-alphanumeric characters.
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.
