Did you set your authorizer correctly? http://docs.datastax.com/en/cassandra/1.2/cassandra/security/secure_config_native_authorize_t.html
-Russ From: Dan Jatnieks Reply-To: <user@cassandra.apache.org> Date: Wednesday, August 5, 2015 at 5:03 PM To: <user@cassandra.apache.org> Subject: Re: only grant select , but still can modify data Hi Rock, I was not able to reproduce this problem using C* 2.2 and DevCenter 1.4. What versions are you using? Did you check that the DevCenter connection properties are using the "readonly" account and that any existing connection was closed and re-opened? Did you get the expected result with cqlsh? dan On Mon, Aug 3, 2015 at 7:12 PM, rock zhang <r...@alohar.com> wrote: Hi All, I want to create a readonly account, so i run the following command following: http://docs.datastax.com/en/cassandra/1.2/cassandra/security/security_config_native_authenticate_t.html CREATE USER readonly WITH PASSWORD 'xxxx' ; GRANT SELECT ON ALL KEYSPACES TO readonly; Then I login DevCenter with readonly account , i still can modify the data, anyone knows why ? Many thanks. I set keyspace system_auth replica as 6 since i have 6 nodes. Thanks Rock -- Dan Jatnieks Software Engineer | d...@datastax.com