ALTER GROUP

ALTER GROUP

7

SQL - Language Statements

ALTER GROUP

change role name or membership

ALTER GROUP

role\_specification

ADD USER

user\_name

\[, \... \] ALTER GROUP

role\_specification

DROP USER

user\_name

\[, \... \]

where

role\_specification

can be:

role\_name

\| CURRENT\_ROLE \| CURRENT\_USER \| SESSION\_USER ALTER GROUP

group\_name

RENAME TO

new\_name

Description
===========

`ALTER GROUP` changes the attributes of a user group. This is an
obsolete command, though still accepted for backwards compatibility,
because groups (and users too) have been superseded by the more general
concept of roles.

The first two variants add users to a group or remove them from a group.
(Any role can play the part of either a "user" or a "group" for this
purpose.) These variants are effectively equivalent to granting or
revoking membership in the role named as the "group"; so the preferred
way to do this is to use [`GRANT`](#sql-grant) or
[`REVOKE`](#sql-revoke).

The third variant changes the name of the group. This is exactly
equivalent to renaming the role with [`ALTER ROLE`](#sql-alterrole).

Parameters
==========

group\_name

:   The name of the group (role) to modify.

user\_name

:   Users (roles) that are to be added to or removed from the group. The
    users must already exist; `ALTER GROUP` does not create or drop
    users.

new\_name

:   The new name of the group.

Examples
========

Add users to a group:

    ALTER GROUP staff ADD USER karl, john;

Remove a user from a group:

    ALTER GROUP workers DROP USER beth;

Compatibility
=============

There is no `ALTER GROUP` statement in the SQL standard.

See Also
========
