Search Postgresql Archives

Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"

Subject: Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Fri, 11 Feb 2022 15:38:50 -0700
Cc: jeremy@xxxxxxxxxxxxxx, Tom Lane PostgreSQL <tgl@xxxxxxxxxxxxx>, pgsql-general list <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <46C22E9C-280C-446E-911F-6915702E554E@yugabyte.com>
References: <0994D6C4-EDF0-4854-B528-88DDE429172E@yugabyte.com> <CAKFQuwZUuL6ek+6noEg13eXJBqK9WKhQww-wn+pqowf+Qub3UA@mail.gmail.com> <46C22E9C-280C-446E-911F-6915702E554E@yugabyte.com>

On Fri, Feb 11, 2022 at 2:44 PM Bryn Llewellyn <bryn@xxxxxxxxxxxx> wrote:

p.s., What's "WADaD", David. Internet search doesn't find me the translation except for, maybe, the Muslim name "Wadad" meaning "Love, friendship.

Working as designed, and documented.

References:
- "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  - From: Bryn Llewellyn
- Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  - From: David G. Johnston
- Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  - From: Bryn Llewellyn