Re: Wrong security context for deferred triggers?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Wrong security context for deferred triggers?
Date: 2024-10-19 17:13:18
Message-ID: CAFj8pRDcy2OaPS7OtceFRhTRq6VKWbdnuawgaX3EXMQVwTR4VA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

so 19. 10. 2024 v 13:02 odesílatel Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
napsal:

> On Sat, 2024-10-19 at 06:17 +0200, Pavel Stehule wrote:
> > Maybe we should document so the trigger is executed with the identity
> used by DML command always,
> > when the trigger function has no SECURITY DEFINER flag?
>
> Good idea. Version 3 has documentation.
>

perfect

all tests passed

I'll mark this patch as ready for committer

Regards

Pavel

>
> Yours,
> Laurenz Albe
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Dolgov 2024-10-19 17:31:56 Re: System views for versions reporting
Previous Message Junwang Zhao 2024-10-19 15:41:17 Re: Using read_stream in index vacuum