DROP ROLE
Description
Drops a role. If a role has been granted to a user, the user still has the privileges associated with this role even 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;