Back to Starrocks

DROP USER

docs/en/sql-reference/sql-statements/account-management/DROP_USER.md

4.1.0345 B
Original Source

DROP USER

import UserManagementPriv from '../../../_assets/commonMarkdown/userManagementPriv.mdx'

DROP USER drops a specified user identity.

<UserManagementPriv />

Syntax

sql
 DROP USER '<user_identity>'

`user_identity`:

 user@'host'
user@['domain']

Examples

Drop user jack@'192.%'.

sql
DROP USER 'jack'@'192.%'