ALTER GROUP()			 SQL Commands			 ALTER GROUP()



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(7)]  or	REVOKE
       [revoke(7)].

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

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(7)], REVOKE [revoke(l)], ALTER ROLE [alter_role(l)]



SQL - Language Statements	  2010-12-14			 ALTER GROUP()