MIME-Version: 1.0
In-Reply-To: <CAEzWdqcimp5dnNOavaSkMCOKW_FVsKC2101g=dFsyjQ-9dA3uw@mail.gmail.com>
References: <CAEzWdqcimp5dnNOavaSkMCOKW_FVsKC2101g=dFsyjQ-9dA3uw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 21 Apr 2024 01:25:35 -0700
Message-ID: <CAKFQuwa+jpZ-pucWc92OCYcwCnj7C_POg8k=5BvbPZyL97R-Jw@mail.gmail.com>
Subject: Re: error in trigger creation
To: yudhi s <learnerdatabase99@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a9fe0a06169710d2"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwa%2BjpZ-pucWc92OCYcwCnj7C_POg8k%3D5BvbPZyL97R-Jw%40mail.gmail.com>
Precedence: bulk

--000000000000a9fe0a06169710d2
Content-Type: text/plain; charset="UTF-8"

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.

--000000000000a9fe0a06169710d2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, April 21, 2024, yudhi s &lt;<a href=3D"mailto:learnerdatabase99@=
gmail.com">learnerdatabase99@gmail.com</a>&gt; wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"ltr">so that it will be able to assign the privil=
ege, so we will be able to create the event trigger without need to run the=
 event trigger script from super user itself?</div></blockquote><div><br></=
div><div>Write a security-definer function owned by superuser and grant app=
_user permission to execute it.</div><div><br></div><div>David J.</div><div=
>=C2=A0</div>

--000000000000a9fe0a06169710d2--