DROP ROLE
Remove a role from a SingleStoreDB Cloud workspace.
Syntax
DROP ROLE [IF EXISTS] 'role_name'
Remarks
IF EXISTS
is available in 6.0.15 or later.This command causes implicit commits. See COMMIT for more information.
See 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'; 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)