cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pinak Pani <>
Subject Authentication is failing.
Date Sun, 28 Sep 2014 09:07:33 GMT

I have been toying around with CQL. I realized when I GRANT SELECT I lose
authentication. Here is the process: Can someone point out what is wrong?

➜  apache-cassandra-2.1.0  bin/cqlsh -u cassandra -p cassandra

Connected to Test Cluster at
[cqlsh 5.0.1 | Cassandra 2.1.0 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.

cqlsh> CREATE USER testuser WITH PASSWORD 'abc';
cqlsh> GRANT SELECT ON demo_cql.grant_test TO testuser;
cqlsh> exit
➜  apache-cassandra-2.1.0  bin/cqlsh -u testuser -p abc -k demo_cql -e
'select * from grant_test'
Connection error: ('Unable to connect to any servers', {'':
Unauthorized(u'code=2100 [Unauthorized] message="User testuser has no
SELECT permission on <table system.schema_triggers> or any of its


View raw message