ALTER GROUP

This page documents the preview version (v2.23). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

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