Re: Need help understanding has_function_privilege

Поиск
Список
Период
Сортировка
От Cosimo Simeone
Тема Re: Need help understanding has_function_privilege
Дата
Msg-id CAD1W9HUKn-u8HnfhVX8e7qib1pYssiuSHp+Lu=5iHzpGJUDMMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need help understanding has_function_privilege  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Need help understanding has_function_privilege
Список pgsql-general
Дерево обсуждения
Hi, and thanks (both of you!)
Shouldn't the
 create role my_user NOINHERIT;
avoid this? And since not, why? :-)



On Thu, 20 Mar 2025 at 15:07, David G. Johnston <david.g.johnston@gmail.com> wrote:
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 по дате отправления: