[
https://issues.apache.org/jira/browse/CASSANDRA-7683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14085517#comment-14085517
]
Jack Krupansky commented on CASSANDRA-7683:
-------------------------------------------
Could you at least update the CQL3 spec to indicate the actual semantics, as I
have suggested?
> Always allow CREATE TABLE IF NOT EXISTS if it exists
> ----------------------------------------------------
>
> Key: CASSANDRA-7683
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7683
> Project: Cassandra
> Issue Type: Wish
> Components: Core
> Reporter: Jens Rantil
> Priority: Minor
>
> Background: I have a table that I'd like to make sure exists when I boot up
> my application. To make the life easier for our developers I execute an
> `ALTER TABLE IF EXISTS`.
> In production I am using user based authorization and for security reasons
> regular production users are not allowed to CREATE TABLEs.
> Problem: When a user without CREATE permission executes `ALTER TABLE IF
> EXISTS` for a table that already exists, the command fails telling me the
> user is not allowed to execute `CREATE TABLE`. It feels kinda ridiculous that
> this fails when I'm not actually creating the table.
> Proposal: That the permission check only should be done if the table is only
> actually to be created.
> Workaround: Right now, I have a boolean that checks if in production and in
> that case don't try to create the table. Another approach would be to
> manually check if the table exists.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
