cassandra - only superuser is allowed to perform CREATE USER queries

cassandra cql cqlsh
hawkeye picture hawkeye · Jun 14, 2014 · Viewed 9.6k times · Source

I'm logging in with on Ubuntu 14.10 on Cassandra 2.0.8 with Java 1.7.0_60-b19

cqlsh -u cassandra -p cassandra

I'm running:

CREATE USER a WITH PASSWORD 'a' NOSUPERUSER;

I'm getting the error:

Bad Request: Only superusers are allowed to perform CREATE USER queries

The problem with reasoning - I am logged in as the superuser.

My question is: If I'm logged into cqlsh as the Cassandra user, why am I told that I'm not the superuser?

Answer

kkmishra picture kkmishra · Jun 14, 2014

You need to enable PasswordAuthenticator in cassandra.yaml file. To enable PasswordAuthenticator you need to change authenticator property in cassandra.yaml

Change

authenticator: AllowAllAuthenticator

to 

authenticator: PasswordAuthenticator

After that login with following command and then you will be able to add new user

cqlsh -u cassandra -p cassandra

Related questions

How do you create the first user in Cassandra DB

How does one create the first user in a cassandra database? I tried: CREATE USER username WITH PASSWORD ""; and its says: Bad Request: Only superusers are allowed to perform CREATE USER queries But I have never created a user before …

Read More
Is there a clear equivalent of 'show keyspaces' in cqlsh 2?

What cqlsh command can I use to quickly see the keyspaces in a cluster? cqlsh does not provide show keyspaces and describe cluster isn't as concise as I want. I'm working using the following specifications: cqlsh 2.2.0, Cassandra 1.1.10, CQL spec 2.0.0, Thrift …

Read More
Executing CQL through Shell Script?

I am trying to execute the CQL commands from shell script. I am able to connect to the cqlsh (CQL version i'm using is 1.1.18) but unable to send the queries to cql. Any ideas or suggestion how to proceed on …

Read More