PostgreSQL said: permission denied for schema

Question

I have a multi-tenant PostgreSQL db on a Ruby on Rails app, and when I try to access to tables on some schemas on Postico, I get the following error:

Failed to load table schema.
Query failed
PostgreSQL said: permission denied for schema coaching

I tried to run: GRANT USAGE ON SCHEMA "lacerba-api" TO "postico7" but I get ERROR: permission denied for schema lacerba-api

Of course my user have writing permission on the db.

Any idea how to solve it?

Answer 1

My guess is that your user doesn't have permission to read tables in the coaching schema. You can try granting your user permission to read tables in that schema:

GRANT SELECT ON SCHEMA coaching TO postico7