Re: Triggers on underlying tables of updatable views

On Mon, 2021-11-22 at 12:06 +0000, PG Doc comments form wrote:
> "Note that the user performing the insert, update or delete on the view must
> have the corresponding insert, update or delete privilege on the view. In
> addition the view's owner must have the relevant privileges on the
> underlying base relations, but the user performing the update does not need
> any permissions on the underlying base relations (see Section 41.5)."
>
> Could it be made more clear that triggers on a underlying table of an
> updatable view are still executed with the permissions of the user
> performing an insert/update/delete on the view?

But that is not the case: that trigger will be executed with the permissions
of the owner of the underlying table.

Yours,
Laurenz Albe