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
