Jens Rantil created CASSANDRA-7683:
--------------------------------------
Summary: 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)
