/usr/man2/cat.l/alter_group.l.Z

NAME

       ALTER GROUP - change role name or membership

SYNOPSIS

       ALTER GROUP groupname ADD USER username [, ... ]
       ALTER GROUP groupname DROP USER username [, ... ]

       ALTER GROUP groupname RENAME TO newname

DESCRIPTION

       ALTER  GROUP  changes the attributes of a user group.  This is an obso-
       lete  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  grant-
       ing  or  revoking membership in the role named as the ``group''; so the
       preferred way  to  do  this  is  to  use  GRANT  [grant(l)]  or  REVOKE
       [revoke(l)].

       The third variant changes the name of the group. This is exactly equiv-
       alent to renaming the role with ALTER ROLE [alter_role(l)].

PARAMETERS

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

       username
              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.

       newname
              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

       GRANT [grant(l)], REVOKE [revoke(l)], ALTER ROLE [alter_role(l)]

SQL - Language Statements         2005-11-05                     ALTER GROUP()