Re: Query a role's permission on a function

Try this :-

SELECT proacl
FROM pg_proc
WHERE proname='<Name of function>';

Regards
Chandra

________________________________
From: Kevin Tu <kevintu888(at)gmail(dot)com>
Sent: 06 December 2021 20:34
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)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