Re: Need help understanding has_function_privilege

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Cosimo Simeone <cosimo(dot)simeone(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Need help understanding has_function_privilege
Date: 2025-03-20 15:06:58
Message-ID: CAKFQuwZmk+xvU9WUyX7CudPW7A7M0Jz+nAS+PWZ1dvVpDPLzjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, March 19, 2025, Cosimo Simeone <cosimo(dot)simeone(at)gmail(dot)com>
wrote:
>
>
> true?
> Well... Ok, "whatever"... I revoke it:
> =# revoke execute on function my_schema.my_func(text) from my_user;
> REVOKE
>

Roles can inherit privileges. my_user is inheriting its execute privilege
from PUBLIC. You have to revoke a granted privilege.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nathan Bossart 2025-03-20 15:18:16 Re: Disabling vacuum truncate for autovacuum
Previous Message Tom Lane 2025-03-20 14:31:39 Re: After upgrading libpq, the same function(PQftype) call returns a different OID