[42501] ERROR: permission denied for relation <table>


Hello! I'm new here and with DataGrip, I installed the platform yesterday and today I connected to a Redshift cluster for the first time. I can see all databases and schemas available in the cluster, however, when I try to run a simple select in any tables in a schema, I get the message:

"[42501] ERROR: permission denied for relation answer"

This is select I'm running:

As you can see, the table "answer" is available under the dwh schema:

And I get this error:

Any idea what's happening? Do I need to change any settings since it's a fresh install?

All help is appreciated!


There is something to do with Postgres permissions like https://stackoverflow.com/a/15522548/8203759

Check the all necessary rights are delegated to the database and table. 



This error still persist especially when using PostgreSQL as your database of choicepersists


I followed the below procedure; it's

If you checked your PostgreSQL service connection and its okay, deactivate the current connection and start another one 

Please reproduce this issue and upload the idea log from Help - Show Log in Files onto our FTP https://uploads.jetbrains.com/

Include the upload id in your reply

Please sign in to leave a comment.