Postgres Pro
Downloads
Home   >   mailing lists

Thread: Execute permission to function

Execute permission to function

From
arun chirappurath
Date:
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

Re: Execute permission to function

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

 
and not able to script out objects from pg_admin

What error message(s)?

Re: Execute permission to function

From
"David G. Johnston"
Date:
On Monday, June 24, 2024, arun chirappurath <arunsnmimt@gmail.com> 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 execution.  The per-object grant system is required.

David J.

Re: Execute permission to function

From
Adrian Klaver
Date:
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

Re: Execute permission to function

From
arun chirappurath
Date:

Hi,

Only see select script here in pg_admin..

image.png

Thanks,
Arun

On Mon, 24 Jun 2024 at 18:25, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Mon, Jun 24, 2024 at 6:29 AM 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

 
and not able to script out objects from pg_admin

What error message(s)?
Attachment

Re: Execute permission to function

From
Adrian Klaver
Date:

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?

Do those parameters work if you try to connect with psql?

If not what is the complete error message?

> 
> image.png
> 
> Thanks,
> Arun
> 
> On Mon, 24 Jun 2024 at 18:25, Ron Johnson <ronljohnsonjr@gmail.com 
> <mailto:ronljohnsonjr@gmail.com>> wrote:
> 
>     On Mon, Jun 24, 2024 at 6:29 AM arun chirappurath
>     <arunsnmimt@gmail.com <mailto: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
>     <https://www.postgresql.org/docs/14/sql-grant.html>
> 
>         and not able to script out objects from pg_admin
> 
> 
>     What error message(s)?
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com