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, TiDB Cloud Lake can't drop the grants from the role automatically.

Examples

DROP ROLE role1;