[ https://issues.apache.org/jira/browse/CASSANDRA-15020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16785049#comment-16785049 ]
Vinay Chella edited comment on CASSANDRA-15020 at 3/5/19 11:52 PM: ------------------------------------------------------------------- +1 I also applied this patch on 2.2 as well since this issue exists on 2.2 too. Committed to 2.2 and up as [53db417b3cd918d61b9ca1a3662495c8a32605f1|https://github.com/apache/cassandra/commit/53db417b3cd918d61b9ca1a3662495c8a32605f1] Thank you [~lucinda] and [~cscotta]. Thank you [~zznate] for reviewing it offline. was (Author: vinaykumarcse): +1 I also applied this patch on 2.2 as well since this issue exists on 2.2 too. Committed to 2.2 and up as [53db417b3cd918d61b9ca1a3662495c8a32605f1|https://github.com/apache/cassandra/commit/53db417b3cd918d61b9ca1a3662495c8a32605f1] > Invalid CQL in documentation > ---------------------------- > > Key: CASSANDRA-15020 > URL: https://issues.apache.org/jira/browse/CASSANDRA-15020 > Project: Cassandra > Issue Type: Improvement > Components: Documentation/Website > Reporter: Liudmila Kornilova > Assignee: C. Scott Andreas > Priority: Trivial > Fix For: 2.2.15, 3.0.19, 3.11.5, 4.0 > > Attachments: CASSANDRA-15020-3.0.patch, > CASSANDRA-15020-trunk-3.11.patch > > > [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; > -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org