Database Reference
In-Depth Information
Figure 4-3
.
Changing the strategy class is not possible with the system keyspace
This means we cannot alter the
system
keyspace either.
•
Next, let's try to drop the
system
keyspace:
drop keyspace system;
Figure 4-4
.
Dropping system keyspace is not an option
With these examples we can conclude that modifying the
system
keyspace is not
permissible; however we can modify data present in column families under the
sys-
tem
keyspace.
Accessing system_auth Keyspace with Authentication
Enabled
Cassandra's binary distribution comes with two authenticators:
Pass-
wordAuthenticator
and
AllowAllAuthenticator
. With
Pass-
wordAuthenticator
enabled, Cassandra validates users by their names and
hashed passwords. These user credentials are stored in the
sys-
tem_auth.credentials
table.
In this recipe, we will discuss managing user credentials and accessing the
sys-
tem_auth
keyspace using
PasswordAuthenticator
. With authentication en-
abled we need to provide the user name and password while connecting to the Cas-
sandra server. Cassandra stores the user name and hashed password under the creden-
tials table in this keyspace.
Before we start, we need to enable authentication in
cassandra.yaml
as fol-
lows:
authenticator:
org.apache.cassandra.auth.PasswordAuthenticator