REVOKE ROLE

Revoke a role from the role or user.

Syntax

REVOKE ROLE <role_name>
FROM { ROLE | USER } <role_or_user_name>

Parameters

{{< sql-section file="data/sql/roles.json" data="revokingRoleParameters" >}}

Example

Revoke role from a user

REVOKE ROLE role1
FROM USER "user@dremio.com"