To see schemas accessible by a group on redshift:
SELECT * FROM svv_schema_privileges WHERE identity_name = 'my_group_name';