Cloudera Docs

REVOKE ROLE statement

The REVOKE statement removes the role assigned to the group or a user.

REVOKE ROLE from a group

Syntax:

REVOKE ROLE role_name FROM GROUP group_name

REVOKE ROLE from a user

Syntax:

REVOKE ROLE <role_name> FROM USER <user_name>;

Example:

This example show how to revoke the grant_revoke_test_ALL_SERVER role from the getuser user:

REVOKE ROLE grant_revoke_test_ALL_SERVER FROM USER getuser;