[
https://issues.apache.org/jira/browse/CASSANDRA-15020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16785088#comment-16785088
]
C. Scott Andreas commented on CASSANDRA-15020:
----------------------------------------------
Thanks, [~vinaykumarcse]!
> 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: [email protected]
For additional commands, e-mail: [email protected]
