On this page 
Warning:
CockroachDB v2.1 is no longer supported as of April 30, 2020. For more details, refer to the Release Support Policy.
The DROP USER statement removes one or more SQL users.
Tip:
You can also use the cockroach user rm command to remove users.Required privileges
The user must have the DELETE privilege on the system.users table.
Synopsis
Parameters
| Parameter | Description |
|---|---|
user_name |
The username of the user to remove. To remove multiple users, use a comma-separate list of usernames. You can use SHOW USERS to find usernames. |
Example
All of a user's privileges must be revoked before the user can be dropped.
In this example, first check a user's privileges. Then, revoke the user's privileges before removing the user.
> SHOW GRANTS ON test.customers FOR mroach;
+-----------+--------+------------+
| Table | User | Privileges |
+-----------+--------+------------+
| customers | mroach | CREATE |
| customers | mroach | INSERT |
| customers | mroach | UPDATE |
+-----------+--------+------------+
(3 rows)
> REVOKE CREATE,INSERT,UPDATE ON test.customers FROM mroach;
> DROP USER mroach;
See also
cockroach usercommandCREATE USERSHOW USERSGRANTSHOW GRANTS- Create Security Certificates
- Other SQL Statements
Was this helpful?
