public inbox for [email protected]  

help / color / mirror / Atom feed

From: yudhi s <[email protected]>
To: pgsql-general <[email protected]>
Subject: error in trigger creation
Date: Sun, 21 Apr 2024 13:42:49 +0530
Message-ID: <CAEzWdqcimp5dnNOavaSkMCOKW_FVsKC2101g=dFsyjQ-9dA3uw@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: error in trigger creation
  In-Reply-To: <CAEzWdqcimp5dnNOavaSkMCOKW_FVsKC2101g=dFsyjQ-9dA3uw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox