> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# REVOKE Function (UDF/UDTF) Permission

Permissions relating to
[UDFs/UDTFs](https://docs.kinetica.com/content/security/sec_concepts.md#security-concepts-permissions-function) and
[Python UDF function environments](https://docs.kinetica.com/content/udf/python/writing.md#udf-python-func-env)
that have been [granted](https://docs.kinetica.com/content/sql/security/grant-function-udf-udtf-permission.md#sql-security-priv-mgmt-udf-grant)
directly to
[users](https://docs.kinetica.com/content/security/sec_concepts.md#security-concepts-users) or
[roles](https://docs.kinetica.com/content/security/sec_concepts.md#security-concepts-roles) can be revoked.

```sql title="REVOKE Function (UDF/UDTF) Permission Syntax" theme={null}
REVOKE <EXECUTE | ADMIN> [PRIVILEGES]
ON <ALL FUNCTIONS | FUNCTION < <function name> | * >>
FROM <user name | role name>
```

```sql title="REVOKE Create Function (UDF/UDTF) Permission Syntax" theme={null}
REVOKE CREATE FUNCTION [PRIVILEGES]
FROM <user name | role name>
```

## Examples

To revoke execute on the **udf\_sos\_py\_proc** *UDF* from **udf\_user**:

```sql REVOKE Function Execute Permission Example theme={null}
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**:

```sql REVOKE Function Administrative Permission Example theme={null}
REVOKE ADMIN ON FUNCTION * FROM udf_user
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.