Re: error in trigger creation

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: yudhi s <learnerdatabase99(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: error in trigger creation
Date: 2024-04-21 08:25:35
Message-ID: CAKFQuwa+jpZ-pucWc92OCYcwCnj7C_POg8k=5BvbPZyL97R-Jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday, April 21, 2024, yudhi s <learnerdatabase99(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message yudhi s 2024-04-21 08:55:44 Re: error in trigger creation
Previous Message yudhi s 2024-04-21 08:12:49 error in trigger creation