Can't query a table - permission denied

faq

#1

I can’t run queries on some of our tables. For example, I get this message: “permission denied for relation pardotvisitoractivity”


#2

It looks like you don’t have permissions for tables in any schema other than public. To avoid this issue in the future, run something like grant all schema foo to public so existing users can read from tables in the schema.