> ## 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 Data Source Permission

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

[Permissions](/content/security/sec_concepts#security-concepts-permissions-datasource) on
[data sources](/content/sql/ddl/create-data-source#sql-create-data-source)
that have been [granted](/content/sql/security/grant-data-source-permission#sql-security-priv-mgmt-ds-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 Data Source Permission Syntax" theme={null}
REVOKE <CONNECT | ADMIN> [PRIVILEGES]
ON <ALL DATA SOURCES [IN [SCHEMA] <schema reference>] | DATA SOURCE <data source reference>>
FROM <user name | role name>
```

```sql title="REVOKE Create Data Source Permission Syntax" theme={null}
REVOKE CREATE [PRIVILEGES] ON DATA SOURCES
[IN [SCHEMA] <schema reference>]
FROM <user name | role name>
```

## Examples

To revoke connect access on the *data source* named **kin\_ds** from
the **auser** *user*:

```sql REVOKE Data Source Use Permission Example theme={null}
REVOKE CONNECT ON DATA SOURCE kin_ds FROM auser
```

To revoke administrative access on the *data source* named **kin\_ds\_anon** from
the **auser** *user*:

```sql REVOKE Data Source Administrative Permission Example theme={null}
REVOKE ADMIN ON DATA SOURCE kin_ds_anon FROM auser
```


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