Postgres Pro
Downloads
Home   >   mailing lists

Re: Query a role's permission on a function - Mailing list pgsql-admin

From Chandra Juthuga
Subject Re: Query a role's permission on a function
Date
Msg-id AS8P194MB1639A936BC8EE90BC6DD340AE56D9@AS8P194MB1639.EURP194.PROD.OUTLOOK.COM
Whole thread Raw
In response to Query a role's permission on a function  (Kevin Tu <kevintu888@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Kevin Tu
Date:
Subject: Query a role's permission on a function
Next
From: Tom Lane
Date:
Subject: Re: Query a role's permission on a function