IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN POSTGRESQL
IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN POSTGRESQL To identify a role has execute permission on function, PostgreSQL has a catalog function(has_function_privilege) which makes it easy. Below is the simple example. I have created a simple schema test with a function row_count() which return the row count of employee table. I have grated execut…