Re: Execute permission to function

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: arun chirappurath <arunsnmimt(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Execute permission to function
Date: 2024-06-24 13:14:42
Message-ID: CAKFQuwZ5azsHShxp4fa4TuVLx-GydfpHVEbCBgLXyk7mQZ3B_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday, June 24, 2024, arun chirappurath <arunsnmimt(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2024-06-24 13:30:44 Re: 2FA - - - was Re: Password complexity/history - credcheck?
Previous Message o1bigtenor 2024-06-24 12:59:31 2FA - - - was Re: Password complexity/history - credcheck?