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
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.