Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
DROP ROLE
Info
SingleStore Managed Service does not support this command.
Remove a role from a SingleStore DB cluster.
Syntax
DROP ROLE [IF EXISTS] 'role_name'
Remarks
IF EXISTSis available in 6.0.15 or later.
Example
SHOW ROLES;
+-------------+
| Roles |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)
DROP ROLE 'role_name_0';
Query OK, 0 rows affected (0.13 sec)
SHOW ROLES;
+-------------+
| Roles |
+-------------+
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
3 rows in set (0.00 sec)
