DROP ROLE
May 28, 2026 ยท View on GitHub
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_adminrole can drop a role. - StarRocks system-defined roles cannot be dropped.
:::
Syntax
DROP ROLE <role_name>
Examples
Drop a role.
DROP ROLE role1;