Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
ALTER GROUP
Changes a user group. Use this command to add users to the group, drop users from the group, or rename the group.
Syntax
ALTER GROUP group_name { ADD USER username [, ... ] | DROP USER username [, ... ] | RENAME TO new_name }
Parameters
- group_name
-
Name of the user group to modify.
- ADD
-
Adds a user to a user group.
- DROP
-
Removes a user from a user group.
- username
-
Name of the user to add to the group or drop from the group.
- RENAME TO
-
Renames the user group. Group names beginning with two underscores are reserved for Amazon Redshift internal use. For more information about valid names, see Names and identifiers.
- new_name
-
New name of the user group.
Examples
The following example adds a user named DWUSER to the ADMIN_GROUP group.
ALTER GROUP admin_group ADD USER dwuser;
The following example renames the group ADMIN_GROUP to ADMINISTRATORS.
ALTER GROUP admin_group RENAME TO administrators;
The following example adds two users to the group ADMIN_GROUP.
ALTER GROUP admin_group ADD USER u1, u2;
The following example drops two users from the group ADMIN_GROUP.
ALTER GROUP admin_group DROP USER u1, u2;