DROP USER
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Statements for MariaDB Xpand
Topics on this page:
Overview
Deletes a user account.
USAGE
Common Syntax:
DROP USER [IF EXISTS] <xpand_user_name> [, <xpand_user_name>] ...
DETAILS
MariaDB Xpand's DROP USER statement has some differences from MariaDB Enterprise Server:
The user account can't be specified using
CURRENT_USER,CURRENT_USER(), orSESSION_USER()
EXAMPLES
DROP USER
To delete a user:
DROP USER usr1;
Delete Multiple Users
To delete multiple users at once, list them in the DROP USER statement:
DROP USER usr1, usr2, usr3;
If some of the users in the argument list do not exist, MariaDB Xpand returns an error listing non-existing users it was unable to drop, and no existing users named in the argument list get deleted.