ALTER GROUP

Synopsis

ALTER GROUP is used 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.

See also

• ALTER ROLE
• CREATE ROLE
• DROP ROLE
• GRANT
• REVOKE