DROP ROLE

DROP ROLE drops a role. If a role has been granted to a user, the user will lose the privileges associated with this role after the role is dropped.

:::tip

• Only users with the user_admin role can drop a role.
• StarRocks system-defined roles cannot be dropped.

:::

Syntax

DROP ROLE <role_name>

Examples

Drop a role.

DROP ROLE role1;