My user (analystperson) cannot see the Development schema (and the tables/views inside this schema) at all. I have given all of the grants below but they still cannot see it. I have rerun everything below- it's weird as the user can see other schemas on this database but just not this one.
GRANT ROLE ROLE_USER_GROUP_ANALYST TO USER analystperson;
Grant OPERATE ON WAREHOUSE QUERY_WH TO ROLE ROLE_USER_GROUP_ANALYST;
GRANT USAGE ON SCHEMA DEV_DW.DEVELOPMENT to role ROLE_USER_GROUP_ANALYST;
GRANT SELECT ON ALL TABLES IN SCHEMA DEV_DW.DEVELOPMENT TO ROLE ROLE_USER_GROUP_ANALYST;
GRANT SELECT ON ALL VIEWS IN SCHEMA DEV_DW.DEVELOPMENT TO ROLE ROLE_USER_GROUP_ANALYST;
GRANT SELECT ON FUTURE TABLES IN SCHEMA DEV_DW.DEVELOPMENT TO ROLE ROLE_USER_GROUP_ANALYST;
GRANT SELECT ON FUTURE VIEWS IN SCHEMA DEV_DW.DEVELOPMENT TO ROLE ROLE_USER_GROUP_ANALYST;
I feel like I have given the user everything via assigning it the ROLE_USER_GROUP_ANALYST role.
Am I missing something?