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(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 2008-09-19 ALTER GROUP()
postgresql 8.3.4 - Generated Thu Oct 2 07:48:38 CDT 2008