MIME-Version: 1.0
From: arun chirappurath <arunsnmimt@gmail.com>
Date: Mon, 24 Jun 2024 15:59:01 +0530
Message-ID: <CAA23SdshNVty9AHU8cKcm+K5OYrFczuMDNdHZh7SZJ-+2n22FQ@mail.gmail.com>
Subject: Execute permission to function
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a0a966061ba04098"
Archived-At: <https://www.postgresql.org/message-id/CAA23SdshNVty9AHU8cKcm%2BK5OYrFczuMDNdHZh7SZJ-%2B2n22FQ%40mail.gmail.com>
Precedence: bulk

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

Hi all

I am using rds postgres 14. I have created few users and added them to
pg_readall_data and pg_write_alldata groups


They are able to read all data and do update in tables

However they can't execute functions and not able to script out objects
from pg_admin

Any other role to be added?

Thanks,
Arun

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

<div dir=3D"auto">Hi all<div dir=3D"auto"><br></div><div dir=3D"auto">I am =
using rds postgres 14. I have created few users and added them to pg_readal=
l_data and pg_write_alldata groups</div><div dir=3D"auto"><br></div><div di=
r=3D"auto"><br></div><div dir=3D"auto">They are able to read all data and d=
o update in tables</div><div dir=3D"auto"><br></div><div dir=3D"auto">Howev=
er they can&#39;t execute functions and not able to script out objects from=
 pg_admin</div><div dir=3D"auto"><br></div><div dir=3D"auto">Any other role=
 to be added?</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks,</d=
iv><div dir=3D"auto">Arun</div></div>

--000000000000a0a966061ba04098--