> ## 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

<a id="sql-security-priv-mgmt-udf-revoke" />

Permissions relating to
[UDFs/UDTFs](/content/security/sec_concepts#security-concepts-permissions-function) and
[Python UDF function environments](/content/udf/python/writing#udf-python-func-env)
that have been [granted](/content/sql/security/grant-function-udf-udtf-permission#sql-security-priv-mgmt-udf-grant)
directly to
[users](/content/security/sec_concepts#security-concepts-users) or
[roles](/content/security/sec_concepts#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.