Re: error in trigger creation - Mailing list pgsql-general

From David G. Johnston
Subject Re: error in trigger creation
Date
Msg-id CAKFQuwYu8w7BMX_9xEP1t5ULT7pV-qO1Yotn1qtdMuEpWCqhFg@mail.gmail.com
Whole thread Raw
In response to Re: error in trigger creation  (yudhi s <learnerdatabase99@gmail.com>)
Responses Re: error in trigger creation
Re: error in trigger creation
List pgsql-general
On Sunday, April 21, 2024, yudhi s <learnerdatabase99@gmail.com> wrote:
On Sun, Apr 21, 2024 at 1:55 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sunday, April 21, 2024, yudhi s <learnerdatabase99@gmail.com> wrote:
so that it will be able to assign the privilege, so we will be able to create the event trigger without need to run the event trigger script from super user itself?

Write a security-definer function owned by superuser and grant app_user permission to execute it.

David J.
 

Thank You David.

 Are you saying something like below, in which we first create the function from super user and then execute the grant? But doesn't that mean, each time we want to create a new event trigger we have to be again dependent on the "super user" to modify the security definer function?

Dynamic SQL.  See “execute” in plpgsql.

David J.
 

pgsql-general by date:

Previous
From: Lok P
Date:
Subject: Re: Logging statement having any threat?
Next
From: Tom Lane
Date:
Subject: Re: error in trigger creation