[ https://issues.apache.org/jira/browse/CASSANDRA-10022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14679071#comment-14679071 ]
Aleksey Yeschenko commented on CASSANDRA-10022: ----------------------------------------------- I'm afraid this wouldn't work. We would still require you to have the {{MODIFY}} permission to run those queries (if anything, for compatibility reasons), and if you have {{MODIFY}}, then you'll be able to omit {{IF NOT EXIST}} and do anything anyway. Perhaps CASSANDRA-8303 is what you really need. Give a role {{MODIFY}} permission, but take away the right to perform non-LWT updates. > Add INSERT permission > --------------------- > > Key: CASSANDRA-10022 > URL: https://issues.apache.org/jira/browse/CASSANDRA-10022 > Project: Cassandra > Issue Type: Improvement > Components: Core > Reporter: Vovodroid > > Hi, > currently there is MODIFY permission in C*. It would be nice to add specific > INSERT permission, that would act as 'IF NOT EXIST' option specified. > Imagine distributed application (e.g. mobile), that each its instance should > add something to table, but shouldn't be able to alter/delete existing data. > Regards. -- This message was sent by Atlassian JIRA (v6.3.4#6332)