DROP USER

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

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 user command
• CREATE USER
• SHOW USERS
• GRANT
• SHOW GRANTS
• Create Security Certificates
• Other SQL Statements

Was this page helpful?
YesNo