ALTER GROUP

Function

ALTER GROUP modifies the attributes of a user group.

Precautions

ALTER GROUP is an alias for ALTER ROLE, and it is not a standard SQL command and not recommended. Users can use ALTER ROLE directly.

Syntax

• Add users to a group.

  1 2	ALTER GROUP group_name ADD USER user_name [, ... ];

• Remove users from a group.

  1 2	ALTER GROUP group_name DROP USER user_name [, ... ];

• Change the name of the group.

  1 2	ALTER GROUP group_name RENAME TO new_name;

Parameter Description

See the Example in ALTER ROLE.

Helpful Links

CREATE GROUP, DROP GROUP, ALTER ROLE