Redshift Permissions


#1

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.

TIA


#2

Hey @jrpeck1989,

I think you’ll also need to grant the user usage on the schema:

GRANT USAGE ON SCHEMA <schema_name> TO <redshift_user>;

Best,
Colm


#3

That’s the one! Knew it would be straightforward.

Thanks!
JP