Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

DROP ROLE

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 Permissions Matrix for the required permissions.

Example

SQL

SHOW ROLES;

+-------------+
| Roles       |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)

SQL

DROP ROLE 'role_name_0';

SHOW ROLES;

+-------------+
| Roles       |
+-------------+
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
3 rows in set (0.00 sec)