Re: Execute permission to function

2024-06-24 Thread Adrian Klaver
On 6/24/24 11:10 AM, arun chirappurath wrote: Hi, Only see select script here in pg_admin.. I don't see any active servers in the Browser pane. Have you done?: https://www.pgadmin.org/docs/pgadmin4/8.8/connecting.html If you have set up a server what connection parameters did you use?

Re: Execute permission to function

2024-06-24 Thread Adrian Klaver
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

Re: Execute permission to function

2024-06-24 Thread David G. Johnston
On Monday, June 24, 2024, arun chirappurath wrote: > > However they can't execute functions > Community PG at least gives the public pseudo-role permission to execute all functions it can see (i.e., schema access permitted). But no, there is no predefined role that enables that function executi

Re: Execute permission to function

2024-06-24 Thread Ron Johnson
On Mon, Jun 24, 2024 at 6:29 AM 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 > https

Execute permission to function

2024-06-24 Thread arun chirappurath
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? Th