Managing access to SQL functions
Before a user can execute a user-defined SQL function, he or she must have USAGE privileges on the schema and EXECUTE privileges on the defined function.
Before a user can execute a user-defined SQL function, he or she must have USAGE privileges on the schema and EXECUTE privileges on the defined function. Only the superuser or owner can grant/revoke EXECUTE usage on a function.
To grant EXECUTE privileges to user Fred on the myzeroifnull function:
=> GRANT EXECUTE ON FUNCTION myzeroifnull (x INT) TO Fred;
To revoke EXECUTE privileges from user Fred on the myzeroifnull function:
=> REVOKE EXECUTE ON FUNCTION myzeroifnull (x INT) FROM Fred;