public inbox for [email protected]  
help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: arun chirappurath <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Execute permission to function
Date: Mon, 24 Jun 2024 06:14:42 -0700
Message-ID: <CAKFQuwZ5azsHShxp4fa4TuVLx-GydfpHVEbCBgLXyk7mQZ3B_A@mail.gmail.com> (raw)
In-Reply-To: <CAA23SdshNVty9AHU8cKcm+K5OYrFczuMDNdHZh7SZJ-+2n22FQ@mail.gmail.com>
References: <CAA23SdshNVty9AHU8cKcm+K5OYrFczuMDNdHZh7SZJ-+2n22FQ@mail.gmail.com>

On Monday, June 24, 2024, arun chirappurath <[email protected]> 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.


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Execute permission to function
  In-Reply-To: <CAKFQuwZ5azsHShxp4fa4TuVLx-GydfpHVEbCBgLXyk7mQZ3B_A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox