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

From Tom Lane
Subject Re: Query a role's permission on a function
Date
Msg-id 3362016.1638826227@sss.pgh.pa.us
Whole thread Raw
In response to Query a role's permission on a function  (Kevin Tu <kevintu888@gmail.com>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Chandra Juthuga
Date:
Subject: Re: Query a role's permission on a function
Next
From: Sivasamy Subramaniam
Date:
Subject: Transaction Size in PostgreSQL