[42501] ERROR: permission denied for relation <table>
Answered
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!
Please sign in to leave a comment.
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
Include the upload id in your reply