Okay, I will admit. I have been dealing w/ Redshift and all of its “isms” over the past several months and it is relatively usable after you get past some of its oddities.

Recently, I created a group for a set of users that will be working across a few schemas. I would like for these users to have carte blanche access to these schemas. I issued:

grant all on schema <schema_name> to group <group_name>;

But that wasn’t good enough for alter table. So I tried all of the different ways to add grant alter permissions. Basically, this required creating a role and granting alter table to that role.

create role altertablerole;

grant alter table to role altertablerole;

But (and there’s always a but), you can’t grant roles to groups. Only users! Therefore, the following is not possible:

grant role altertablerole to group <group_name>;

You can only grant roles to users.

Let the sadness ensue.