You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

DROP ROLE

Info

MemSQL Helios does not support this command.

Remove a role from a MemSQL cluster.

Syntax

DROP ROLE [IF EXISTS] 'role_name'

Remarks

  • IF EXISTS is available in 6.0.15 or later.

Example

memsql> SHOW ROLES;       
+-------------+
| Roles       |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)

memsql> DROP ROLE 'role_name_0';
Query OK, 0 rows affected (0.13 sec)

memsql> SHOW ROLES;
+-------------+
| Roles       |
+-------------+
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
3 rows in set (0.00 sec)