Kevin Tu <kevintu888@xxxxxxxxx> 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