MIME-Version: 1.0
From: yudhi s <learnerdatabase99@gmail.com>
Date: Sun, 21 Apr 2024 13:42:49 +0530
Message-ID: <CAEzWdqcimp5dnNOavaSkMCOKW_FVsKC2101g=dFsyjQ-9dA3uw@mail.gmail.com>
Subject: error in trigger creation
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b890cd061696e30d"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqcimp5dnNOavaSkMCOKW_FVsKC2101g%3DdFsyjQ-9dA3uw%40mail.gmail.com>
Precedence: bulk

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

Hi All,
We are seeing privilege issues while creating event triggers. It says the
user "*must be a superuser to create an event trigger*".

So my question is , if we have application user as "app_user" which is
responsible for creating database objects in schema "app_schema" and also
we have all scripts executed in the database through user "app_user" only,
then is there any way to grant necessary privilege or to equip the
app_user, 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? This will ensure that we do not need "super
user" every time, when we want to run scripts to have an event
trigger created for our application schema.
Something like "*grant create event trigger on schema app_schema to
app_user*"?
Regards
Yudhi

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

<div dir=3D"ltr">Hi All, <br>We are seeing privilege issues while creating =
event triggers. It says the user &quot;<i>must be a superuser to create an =
event trigger</i>&quot;. <br><br>So my question is , if we have application=
 user as &quot;app_user&quot; which is responsible for creating database ob=
jects in schema &quot;app_schema&quot; and also we have all scripts execute=
d in the database through user &quot;app_user&quot; only, then is there any=
 way to grant necessary privilege or to equip the app_user, so that it will=
 be able to assign the privilege, so we will be able to create the event tr=
igger without need to run the event trigger script from super user itself? =
This will ensure that we do not need &quot;super user&quot; every time, whe=
n we want to run scripts to have an event trigger=C2=A0created for our appl=
ication schema.=C2=A0<div>Something like &quot;<i>grant create event trigge=
r on schema app_schema to app_user</i>&quot;?<div><span style=3D"color:rgb(=
255,255,255);font-family:&quot;S\0000f6hne Mono&quot;,Monaco,&quot;Andale M=
ono&quot;,&quot;Ubuntu Mono&quot;,monospace;font-size:14px;white-space:pre;=
background-color:rgb(13,13,13)">
</span><div><div>Regards</div><div>Yudhi</div></div></div></div></div>

--000000000000b890cd061696e30d--