Message-ID: <2f54dbb7d59aacacbc4654b0bc56faaebe993e09.camel@cybertec.at>
Subject: Re: Triggers on underlying tables of updatable views
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: max.ziermann@htw-dresden.de, pgsql-docs@lists.postgresql.org
Date: Mon, 22 Nov 2021 16:41:07 +0100
In-Reply-To: <163758281947.26190.10251137266467665332@wrigleys.postgresql.org>
References: 
	<163758281947.26190.10251137266467665332@wrigleys.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/2f54dbb7d59aacacbc4654b0bc56faaebe993e09.camel%40cybertec.at>
Precedence: bulk

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