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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Bryn Llewellyn <bryn(at)yugabyte(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Tom Lane PostgreSQL <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: jeremy(at)musicsmith(dot)net, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
Date: 2022-02-12 00:08:32
Message-ID: b9722779-2448-70f0-dacd-c711cec06a9a@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/11/22 15:48, Adrian Klaver wrote:
> On 2/11/22 15:14, Bryn Llewellyn wrote:
>>> /david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com> wrote:/
>>>
>

>
> Tip if you do:
>
> psql -d test -U postgres -h localhost -E
>
> the -E will get you the queries for the \ meta-commands.
>
> So:
>
> \df+ tag_changeset_fnc
>

Should have mentioned, if you want to include system functions then it
would be:

\dfS+

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas 'ads' Scherbaum 2022-02-12 00:18:04 Re: Can we go beyond the standard to make Postgres radically better?
Previous Message Adrian Klaver 2022-02-11 23:48:29 Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"