Henrik Uggla <henrik.ug...@kristianstad.se> writes:
> I created some materialized views and set a group as owner. My problem is
> that I can't refresh the views. I get "permission denied" even when using the
> postgres super user. If I change the owner to an ordinary user I still can't
> refresh the view as the owner or postgres. Only if I change owner to postgres
> am I able to refresh the view, but only as the postgres user. I've mainly
> tried with Pgadmin4 but also a few times with psql, and the database is
> installed as a docker container. Please help.
Apparently, the view owner lacks select permission on some underlying
table. Pay attention to what is being denied access to.
regards, tom lane
