1 .\\" auto-generated by docbook2man-spec $Revision: 1.1 $
2 .TH "ALTER GROUP" "7" "2003-11-02" "SQL - Language Statements" "SQL Commands"
4 ALTER GROUP \- change a user group
9 ALTER GROUP \fIgroupname\fR ADD USER \fIusername\fR [, ... ]
10 ALTER GROUP \fIgroupname\fR DROP USER \fIusername\fR [, ... ]
12 ALTER GROUP \fIgroupname\fR RENAME TO \fInewname\fR
17 \fBALTER GROUP\fR is used to change a user group. The
18 first two variants add or remove users from a group. Only database
19 superusers can use this command. Adding a user to a group does not
20 create the user. Similarly, removing a user from a group does not
23 The third variant changes the name of the group. Only a database
24 superuser can rename groups.
28 The name of the group to modify.
31 Users which are to be added or removed from the group. The users
35 The new name of the group.
41 ALTER GROUP staff ADD USER karl, john;
44 Remove a user from a group:
47 ALTER GROUP workers DROP USER beth;
52 There is no \fBALTER GROUP\fR statement in the SQL
53 standard. The concept of roles is similar.
55 CREATE GROUP [\fBcreate_group\fR(7)], DROP GROUP [\fBdrop_group\fR(l)]