Re: Query a role's permission on a function

[Chandra Juthuga <shekharjchandra@xxxxxxxxxxxxx>]

Try this :- 

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

Regards

Chandra 

---

From: Kevin Tu <kevintu888@xxxxxxxxx>
Sent: 06 December 2021 20:34
To: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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