Skip to main content

DROP ROLE

Removes the specified role from the system.

Syntax​

DROP ROLE [ IF EXISTS ] <role_name>

Usage Notes​

  • If a role is a grant to users, Databend can't drop the grants from the role automatically.

Examples​

mysql>
drop role role1;