v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

ALTER GROUP

Synopsis

Use the ALTER GROUP statement to alter attributes for a group (role). This is added for compatibility with Postgres. Its usage is discouraged. ALTER ROLE is the preferred way to change attributes of a role.

Syntax

alter_group ::= ALTER GROUP role_specification { ADD | DROP } USER 
                role_name [ , ... ]

role_specification ::= role_name | CURRENT_USER | SESSION_USER

alter_group_rename ::= ALTER GROUP role_name RENAME TO new_role_name

alter_group

ALTERGROUProle_specificationADDDROPUSER,role_name

role_specification

role_nameCURRENT_USERSESSION_USER

alter_group_rename

ALTERGROUProle_nameRENAMETOnew_role_name

See ALTER ROLE for more details.

ALTER GROUP can be used to add or remove roles from a group. Please use GRANT or REVOKE instead. It can also be used to rename a role.

See also