How Can I Revoke Execution Of A Postgresql Function 2GYb0A

All functions access is PUBLIC by default, this means that any role can execute it. To revoke execution, there are 2 steps required:

• Revoke function execution (foo in this case) from PUBLIC:

revoke execute on function foo from public;

• Revoke execution from a particular role (anon in this case):

revoke execute on function foo from anon;

Now anon should get an error when trying to execute the function:

begin;
set local role anon;
select foo();
ERROR:  permission denied for function foo