Обсуждение: Query a role's permission on a function

Поиск
Список
Период
Сортировка

Query a role's permission on a function

От
Kevin Tu
Дата:
Hi team, 

This sounds easy enough, but I can't quite figure out searching around. Can anybody please tell me which catalog table to query to find out whether a role/user has execute permission on a function?  

Thanks in advance,
 
Kevin Tu

Re: Query a role's permission on a function

От
Chandra Juthuga
Дата:
Try this :- 
SELECT proacl 
FROM pg_proc 
WHERE proname='<Name of function>';
Regards
Chandra 

From: Kevin Tu <kevintu888@gmail.com>
Sent: 06 December 2021 20:34
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Query a role's permission on a function
 
Hi team, 

This sounds easy enough, but I can't quite figure out searching around. Can anybody please tell me which catalog table to query to find out whether a role/user has execute permission on a function?  

Thanks in advance,
 
Kevin Tu

Re: Query a role's permission on a function

От
Tom Lane
Дата:
Kevin Tu <kevintu888@gmail.com> writes:
> This sounds easy enough, but I can't quite figure out searching around. Can
> anybody please tell me which catalog table to query to find out whether a
> role/user has execute permission on a function?

I'd suggest using has_function_privilege() instead of trying to duplicate
the logic for yourself.

https://www.postgresql.org/docs/current/functions-info.html

            regards, tom lane