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