Re: Execute permission to function

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: arun chirappurath <arunsnmimt(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Execute permission to function
Date: 2024-06-24 14:44:36
Message-ID: fe5956c5-0cc3-40e5-9e62-afa174b8f8f7@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/24/24 03:29, arun chirappurath 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 and not able to script out objects
> from pg_admin

The above are two separate issues. Provide examples of what you are
doing and the errors you get when you do them.

>
> Any other role to be added?

You probably should take a look at:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Roles.html#Appendix.PostgreSQL.CommonDBATasks.Access

>
> Thanks,
> Arun

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2024-06-24 15:01:47 Re: Password complexity/history - credcheck?
Previous Message Adrian Klaver 2024-06-24 14:32:45 Re: Issue with pgstattuple on Sequences in PostgreSQL