Managing roles in RBAC - Amazon Redshift

Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the blog post .

Managing roles in RBAC

To perform the following actions, use the following commands:

  • To create a role, use the CREATE ROLE command.

  • To rename a role or change the owner of the role, use the ALTER ROLE command.

  • To delete a role, use the DROP ROLE command.

  • To grant a role to a user, use the GRANT command.

  • To revoke a role from a user, use the REVOKE command.

  • To grant system permissions to a role, use the GRANT command.

  • To revoke system permissions from a role, use the REVOKE command.

To view a list of roles in your cluster or workgroup, see SVV_ROLES.