Skip to main content

REVOKE ROLE

Revoke a role from the role or user.

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

Parameters​

<role_name> String

Indicates the name of the role you wish to revoke.

<role_or_user_name> String

Indicates the role or user that you are revoking the role from.

note

Users cannot remove themselves from the ADMIN role. If you are a member of the ADMIN role and wish to be removed from it, another user who has the necessary privileges must remove you.

Example​

Revoke role from a user 
REVOKE ROLE role1
FROM USER "user@dremio.com"