ERROR: permission denied for table <tablename>

PostgreSQL PostgreSQL General Discussion
1

grant select on all tables in schema schemaname to username;

I don’t unserstand what I’m missing.

2

Who is the owner of the table for which you are getting Permission denied?

SELECT tablename, tableowner
FROM pg_tables
WHERE schemaname = 'schemaname';

\dp schemaname.tablename
\dp schemaname.*

Are you encountering this error with existing tables, or with tables created after the GRANT was applied?

3

I think I was missing:
grant usage on schema schemaname to username

Just waiting for the user to test.

4

User has confirmed that this has fixed it.