I’m having what is obviously a really simple issue. I’ve created a new schema and some tables in Redshift, and granted SELECT on all tables in a schema to a read only user that we use in our BI tools.
However, when I try to use the tables in our tools (Tableau and Metabase) I get the same error:
ERROR: permission denied for schema <schema_name>
I’ve ran the following query to see if the user does indeed have SELECT privileges:
SELECT has_table_privilege('read_only_user', 'schema_name.table_name', 'select')
Which has returned TRUE, so I’m a bit at a loss as to why this user cannot access the table or its columns in our BI tools.