Name
ALTER GROUP -- Modifies the structure of a user group.
Synopsis
ALTER GROUP
name
ADD USER
username
[, ... ]
ALTER GROUP
name
DROP USER
username
[, ... ]
Parameters
-
name
-
The name of an existing group to alter.
-
username
-
The names of existing users you wish to add or remove from the specified group. Multiple names are delimited by commas.
Results
-
ALTER GROUP
-
The message returned when an ALTER GROUP modification 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;
ALTER
The next example removes the user jessica from the sales group:
booktown=#
ALTER GROUP sales DROP USER jessica;
ALTER
