DROP USER
Description
The DROP USER statement is used to delete a user.
Syntax
DROP USER '<user_identity>'
Required Parameters
1. <user_identity>
The specified user identity.
Access Control Requirements
The user executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| ADMIN_PRIV | USER or ROLE | This operation can only be performed by users or roles with ADMIN_PRIV permissions |
Example
- Delete user jack@'192.%'
DROP USER 'jack'@'192.%'
