[ https://issues.apache.org/jira/browse/CASSANDRA-8850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14346146#comment-14346146 ]
Aleksey Yeschenko commented on CASSANDRA-8850: ---------------------------------------------- I've been thinking about it a bit. If we don't care too much about emulating Postgres syntactically, can we go with a more consistent (wrt the rest of C* CQL statements) option? Instead of {noformat} CREATE ROLE mike WITH PASSWORD '12345' AND NOSUPERUSER AND LOGIN {noformat} have {noformat} CREATE ROLE mike WITH PASSWORD = '12345' AND SUPERUSER = false AND LOGIN = true {noformat} Instead of {noformat} ALTER ROLE mike WITH NOSUPERUSER AND NOLOGIN {noformat} have {noformat} ALTER ROLE mike WITH SUPERUSER = false AND LOGIN = false {noformat} It also extends nicely to OPTIONS, too. What do you think? > clean up options syntax for create/alter role > ---------------------------------------------- > > Key: CASSANDRA-8850 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8850 > Project: Cassandra > Issue Type: Improvement > Reporter: Sam Tunnicliffe > Assignee: Sam Tunnicliffe > Priority: Minor > Fix For: 3.0 > > Attachments: 8850-v2.txt, 8850.txt > > > {{CREATE/ALTER ROLE}} syntax would be improved by using {{WITH}} and {{AND}} > in a way more consistent with other statements. > e.g. {{CREATE ROLE foo WITH LOGIN AND SUPERUSER AND PASSWORD 'password'}} -- This message was sent by Atlassian JIRA (v6.3.4#6332)