ot;Tom Lane"
mailto:t...@sss.pgh.pa.us>> wrote:
Henrik Uggla
mailto:henrik.ug...@kristianstad.se>> writes:
> The underlying tables are foreign tables. The user has been mapped to a
> foreign user with select permission. I have no problem selecting from the
> for
MATERIALIZED VIEW
kust_havsplan.fornlamning_linje WITH DATA;
2017-11-28 13:58:47.412 UTC [296] ERROR: permission denied for relation
fornlamning_linje
Regards
Henrik
Från: Tom Lane
Skickat: den 28 november 2017 15:25:47
Till: Henrik Uggla
Kopia: pgsql-general
Hi
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 own
