[CASSANDRA-10817] DROP USER is not case-sensitive

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.2.5, 3.0.3, 3.3
• Component/s: Legacy/CQL
• Severity: Low
• Assignee: Marcus Eriksson
• Reporter: Mike Adamson

Authors

Marcus Eriksson

Reviewers

Sam Tunnicliffe

• Created: 04/Dec/15 14:09
• Updated: 16/Apr/19 09:30
• Resolved: 05/Jan/16 09:39

Description

As per the summary DROP USER is not case sensitive, so:

CREATE USER 'Test';
LIST USERS;
 name      | super
-----------+-------
      Test | False
 cassandra |  True
DROP USER 'Test';
InvalidRequest: code=2200 [Invalid query] message="test doesn't exist"

DROP ROLE is case-sensitive and will drop the above user.