[
https://issues.apache.org/jira/browse/CASSANDRA-8850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14345262#comment-14345262
]
Sam Tunnicliffe commented on CASSANDRA-8850:
--------------------------------------------
Certainly, we can do that & I'm also not a fan of having multiple equivalent
expressions for the same thing. The reasoning for making them optional was to
preserve support for things like {{CREATE ROLE r NOSUPERUSER;}} which was
brought along from {{CREATE USER}} syntax. And I assume it was there originally
to emulate postgres.
I'll post a new patch (& a PR for dtests) directly.
> 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.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)
