Feedback-ID: i76984098:Fastmail
Message-ID: <fe5956c5-0cc3-40e5-9e62-afa174b8f8f7@aklaver.com>
Date: Mon, 24 Jun 2024 07:44:36 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Execute permission to function
To: arun chirappurath <arunsnmimt@gmail.com>,
 pgsql-general@lists.postgresql.org
References: <CAA23SdshNVty9AHU8cKcm+K5OYrFczuMDNdHZh7SZJ-+2n22FQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAA23SdshNVty9AHU8cKcm+K5OYrFczuMDNdHZh7SZJ-+2n22FQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/fe5956c5-0cc3-40e5-9e62-afa174b8f8f7%40aklaver.com>
Precedence: bulk

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.klaver@aklaver.com