Alter Group
Modifies the structure of a user group.
Synopsis
ALTER GROUP name ADD USER username [, ... ] ALTER GROUP name DROP USER username [, ... ]
Parameters
nameThe name of an existing group to alter.
usernameThe names of existing users you wish to add or remove from the specified group. Multiple names are delimited by commas.
Results
ALTER GROUPThe message returned when an
ALTER GROUPmodification is successful.
Description
Database superusers can use the ALTER GROUP command to add and remove
specified users from a group. As groups can be allocated privileges, adding members to a group
grants those privileges by proxy. Users must exist before they can be added to a group.
Dropping a user from a group does not drop a user from the system.
Use CREATE GROUP to create a new group and DROP
GROUP to remove a group. Use GRANT and REVOKE
to manage privileges on a group.
Examples
The following example adds the PostgreSQL database users jessica and
william to the sales group:
booktown=# ALTER GROUP sales ADD USER jessica, william;
ALTERThe next example removes the user jessica from the sales group:
booktown=# ALTER GROUP sales DROP USER jessica;
ALTER