Goal: I want to give users "select" access to a schema via a role. The schema will have views based on source tables, but I do not want the users to have access to the source tables.
Steps I've performed so far...
1. Created the role and gave "select" access to the schema
2. Added users to the role
3. Created a view, within the schema, from a source table
When user tries to select from the view, they get an error because they do not have "select" access to the source.
How would I fix?