MIME-Version: 1.0
References: <CAA23SdshNVty9AHU8cKcm+K5OYrFczuMDNdHZh7SZJ-+2n22FQ@mail.gmail.com>
In-Reply-To: <CAA23SdshNVty9AHU8cKcm+K5OYrFczuMDNdHZh7SZJ-+2n22FQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 24 Jun 2024 08:54:43 -0400
Message-ID: <CANzqJaA9auBPQnJHY_45uvyObpV99TRWj+NB5PYrtdVZD8pGXw@mail.gmail.com>
Subject: Re: Execute permission to function
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ac1896061ba2495d"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaA9auBPQnJHY_45uvyObpV99TRWj%2BNB5PYrtdVZD8pGXw%40mail.gmail.com>
Precedence: bulk

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

On Mon, Jun 24, 2024 at 6:29=E2=80=AFAM arun chirappurath <arunsnmimt@gmail=
.com>
wrote:

> 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
>

https://www.postgresql.org/docs/14/sql-grant.html


> and not able to script out objects from pg_admin
>

What error message(s)?

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Jun 24, 2024 at 6:29=E2=80=AFAM a=
run chirappurath &lt;<a href=3D"mailto:arunsnmimt@gmail.com">arunsnmimt@gma=
il.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><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_readall_data and pg_write_alldata groups</div><d=
iv dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto">The=
y are able to read all data and do update in tables</div><div dir=3D"auto">=
<br></div><div dir=3D"auto">However they can&#39;t execute functions </div>=
</div></blockquote><div><br></div><div><a href=3D"https://www.postgresql.or=
g/docs/14/sql-grant.html">https://www.postgresql.org/docs/14/sql-grant.html=
</a><br></div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex"><div dir=3D"auto"><div dir=3D"auto">and not able to script out object=
s from pg_admin</div></div></blockquote><div><br></div><div>What error mess=
age(s)?</div></div></div>

--000000000000ac1896061ba2495d--