To see schemas accessible by a group on redshift:

SELECT * FROM svv_schema_privileges WHERE identity_name = 'my_group_name';

remove the filter to list all groups and the level of schema access they have.