Tom Lane schreef op wo 16-06-2021 om 17:21 [-0400]:
>
> When you select from a view, you need permissions only on the view.
> The view's owner needs permissions on the underlying table(s).
> This is so that views can act as permission gateways.
additionally,
if you want to allow modifications through this view,
have a look at 'with check option' to avoid unwanted permission side-
effects
>
> regards, tom lane
>
>
--
mvg,
Wim Bertels