Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help understanding has_function_privilege - Mailing list pgsql-general

From David G. Johnston
Subject Re: Need help understanding has_function_privilege
Date
Msg-id CAKFQuwZmk+xvU9WUyX7CudPW7A7M0Jz+nAS+PWZ1dvVpDPLzjA@mail.gmail.com
Whole thread Raw
In response to Need help understanding has_function_privilege  (Cosimo Simeone <cosimo.simeone@gmail.com>)
Responses Re: Need help understanding has_function_privilege
List pgsql-general
Tree view
On Wednesday, March 19, 2025, Cosimo Simeone <cosimo.simeone@gmail.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.
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID
Next
From: Adrian Klaver
Date:
Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID