GRANT Function (UDF/UDTF) Permission

Function permissions, which allow management of UDFs/UDTFs, can be granted directly to users or roles.

GRANT Function (UDF/UDTF) Permission Syntax

GRANT <EXECUTE | ADMIN> [PRIVILEGES]
ON <ALL FUNCTIONS | FUNCTION < <function name> | * >>
TO <user name | role name> [WITH GRANT OPTION]

GRANT Create Function (UDF/UDTF) Permission Syntax

GRANT CREATE FUNCTION [PRIVILEGES]
TO <user name | role name> [WITH GRANT OPTION]

Permission	Description
`ADMIN`	Drop the given UDF, and display full configuration about it (includes `EXECUTE` access). When `` is used instead of function name*, gives permission to manage Python UDF function environments.
`EXECUTE`	Run and terminate the given UDF, and display limited configuration about it.
`<function reference>`	The name of the UDF/UDTF to which access is being granted, or `` for all functions. The following forms are valid: <function name>: The specified UDF/UDTF ``: All functions, both existing and future
`CREATE FUNCTION`	Create UDF/UDTF permission
`WITH GRANT OPTION`	Grant this permission with a grant option to grant it to others.

Examples

To grant execute on the udf_sos_py_proc UDF to udf_user:

GRANT Function Execute Permission Example

GRANT EXECUTE ON FUNCTION UDF_SOS_PY_PROC TO udf_user

To grant administrative access on every existing & future UDF, as well as the ability to manage Python UDF environments, to udf_user:

GRANT Function Administrative Permission Example

GRANT ADMIN ON FUNCTION * TO udf_user