Description\n-----------\n\nThe DROP ROLE statement removes one or more MariaDB roles. To use this statement, you must have the global CREATE USER privilege or the DELETE privilege for the mysql database.\n\nDROP ROLE does not disable roles for connections which selected them with SET ROLE. If a role has previously been set as a default role, DROP ROLE does not remove the record of the default role from the mysql.user table. If the role is subsequently recreated and granted, it will again be the user's default. Use SET DEFAULT ROLE NONE to explicitly remove this.\n\nIf any of the specified user accounts do not exist, ERROR 1396 (HY000)results. If an error occurs, DROP ROLE will still drop the roles that do not result in an error. Only one error is produced for all roles which have not been dropped:\n\n``bnf\nERROR 1396 (HY000): Operation DROP ROLE failed for 'a','b','c'\n`\n\nFailed CREATE or DROP operations, for both users and roles, produce the same error code.\n\nIF EXISTS\n\nIf the IF EXISTS` clause is used, MariaDB will return a warning instead of an error if the role does not exist.\n\nExamples\n--------\n\nDROP ROLE journalist;\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/drop-role