[CASSANDRA-15020] Invalid CQL in documentation

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.2.15, 3.0.19, 3.11.5, 4.0-alpha1, 4.0
• Component/s: Documentation/Website
• Assignee: C. Scott Andreas
• Reporter: Liudmila Kornilova

Authors

C. Scott Andreas

• Created: 13/Feb/19 13:00
• Updated: 15/May/20 08:00
• Resolved: 05/Mar/19 23:49

Description

 http://cassandra.apache.org/doc/4.0/cql/security.html

1.

Wrong:

CREATE USER IF EXISTS alice WITH PASSWORD 'password_a' SUPERUSER;
CREATE ROLE IF EXISTS alice WITH PASSWORD = 'password_a' AND LOGIN = true AND SUPERUSER = true;

Correct:

CREATE USER IF NOT EXISTS alice WITH PASSWORD 'password_a' SUPERUSER;
CREATE ROLE IF NOT EXISTS alice WITH PASSWORD = 'password_a' AND LOGIN = true AND SUPERUSER = true; 

 

2. 

 Wrong:

CREATE ROLE alice WITH PASSWORD = 'password_a' WITH LOGIN = true;
CREATE ROLE alice WITH PASSWORD = 'password_a' WITH LOGIN = true;

Correct:

CREATE ROLE alice WITH PASSWORD = 'password_a' AND LOGIN = true;
CREATE ROLE alice WITH PASSWORD = 'password_a' AND LOGIN = true;