How to create a group and add users to group in Redshift

create group group_name;                             
GRANT USAGE ON SCHEMA schema_name TO GROUP group_name;
alter group group_name add user user_name;            
commit;                                              

See also  How to find the size of a Redshift database