DROP ROLE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Remove a role from a SingleStore cluster.
Syntax
DROP ROLE [IF EXISTS] 'role_name'
Remarks
-
IF EXISTS
is available in 6.0. 15 or later. -
This command causes implicit commits.
Refer to COMMIT for more information. -
Refer to the Permission Matrix for the required permission.
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';SHOW ROLES;
+-------------+
| Roles |
+-------------+
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
3 rows in set (0.00 sec)
Last modified: August 18, 2023