[CASSANDRA-18092] Allow DB role names to prefix with a number

• Type: Improvement
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 4.0.x, 4.1.x, 5.x
• Component/s: Feature/Authorization
• Change Category: Operability
• Complexity: Normal
• Platform: All
• Assignee: Unassigned
• Reporter: Johnny Miller
• Created: 05/Dec/22 13:26
• Updated: 07/Mar/23 10:54

Description

Works - CREATE ROLE IF NOT EXISTS test WITH PASSWORD='somepassword' AND LOGIN=true;
 
Works - CREATE ROLE IF NOT EXISTS test123 WITH PASSWORD='somepassword' AND LOGIN=true;
 
Breaks - CREATE ROLE IF NOT EXISTS 123test WITH PASSWORD='somepassword' AND LOGIN=true;
SyntaxException: line 1:26 no viable alternative at input '123' (CREATE ROLE IF NOT EXISTS [123]...){}
 
It would be helpful and more consistent to be able to prefix roles with a numeric value instead of only being able to do this as a suffix.

Env Details are:

[cqlsh 6.0.0 | Cassandra 4.0.3 | CQL spec 3.4.5 | Native protocol v5]