REVOKE Function (UDF/UDTF) Permission

Permissions relating to UDFs/UDTFs and Python UDF function environments that have been granted directly to users or roles can be revoked.

REVOKE Function (UDF/UDTF) Permission Syntax

REVOKE <EXECUTE | ADMIN> [PRIVILEGES]
ON <ALL FUNCTIONS | FUNCTION < <function name> | * >>
FROM <user name | role name>

REVOKE Create Function (UDF/UDTF) Permission Syntax

REVOKE CREATE FUNCTION [PRIVILEGES]
FROM <user name | role name>

Examples

To revoke execute on the udf_sos_py_proc UDF from udf_user:

REVOKE Function Execute Permission Example

REVOKE EXECUTE ON FUNCTION UDF_SOS_PY_PROC FROM udf_user

To revoke administrative access on every existing & future UDF, as well as the ability to manage function environments, from udf_user:

REVOKE Function Administrative Permission Example

REVOKE ADMIN ON FUNCTION * FROM udf_user