From: Laurenz Albe <laurenz.albe@cybertec.at>
To: max.ziermann@htw-dresden.de
To: pgsql-docs@lists.postgresql.org
Subject: Re: Triggers on underlying tables of updatable views
Date: Mon, 22 Nov 2021 16:41:07 +0100
Message-ID: <2f54dbb7d59aacacbc4654b0bc56faaebe993e09.camel@cybertec.at> (raw)
In-Reply-To: <163758281947.26190.10251137266467665332@wrigleys.postgresql.org>
References: <163758281947.26190.10251137266467665332@wrigleys.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: laurenz.albe@cybertec.at, max.ziermann@htw-dresden.de, pgsql-docs@lists.postgresql.org
Subject: Re: Triggers on underlying tables of updatable views
In-Reply-To: <2f54dbb7d59aacacbc4654b0bc56faaebe993e09.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox