ALTER GROUP name ADD USER username [, ... ] ALTER GROUP name DROP USER username [, ... ] |
ALTER GROUP is used to add or remove users from a group. Only database superusers can use this command. Adding a user to a group does not create the user. Similarly, removing a user from a group does not drop the user.
Use CREATE GROUP to create a new group and DROP GROUP to remove a group.
Use CREATE USER to create a new user and DROP USER to remove a user.
Create a group and a user:
CREATE GROUP rhdbgroup1; CREATE USER rhdb1; |
To add a user to the group:
ALTER GROUP rhdbgroup1 ADD USER rhdb1; |
ALTER GROUP rhdbgroup1 DROP USER rhdb1; |
DROP USER rhdb1; DROP GROUP rhdbgroup1; |