Amazon Redshift
Database Developer Guide (API Version 2012-12-01)


Groups are collections of users who are all granted whatever privileges are associated with the group. You can use groups to assign privileges by role. For example, you can create different groups for sales, administration, and support and give the users in each group the appropriate access to the data they require for their work. You can grant or revoke privileges at the group level, and those changes will apply to all members of the group, except for superusers.

To view all user groups, query the PG_GROUP system catalog table:

select * from pg_group;

Creating, Altering, and Deleting Groups

Only a superuser can create, alter, or drop groups.

You can perform the following actions:

  • To create a group, use the CREATE GROUP command.

  • To add users to or remove users from an existing group, use the ALTER GROUP command.

  • To delete a group, use the DROP GROUP command. This command only drops the group, not its member users.