Home > APIs > YSQL > The SQL language > SQL statements >

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

Grammar
Diagram

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

role_specification

alter_group_rename

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.