Re: Execute permission to function - Mailing list pgsql-general

From David G. Johnston
Subject Re: Execute permission to function
Date
Msg-id CAKFQuwZ5azsHShxp4fa4TuVLx-GydfpHVEbCBgLXyk7mQZ3B_A@mail.gmail.com
Whole thread Raw
In response to Execute permission to function  (arun chirappurath <arunsnmimt@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: o1bigtenor
Date:
Subject: 2FA - - - was Re: Password complexity/history - credcheck?
Next
From: Chris Travers
Date:
Subject: Re: 2FA - - - was Re: Password complexity/history - credcheck?