Database Reference
In-Depth Information
4.
We were able to truncate the
users
table, but now let's see whether
we can drop it.
drop table users;
Figure 4-21
shows that we cannot do this, since it is a system
table and restricted by Cassandra for external users.
Figure 4-21
.
Dropping the users table is not allowed
5.
Next, restart the Cassandra server to verify whether the
users
table is
empty (see
Figure 4-22
):
select * from users;
Figure 4-22
.
Default user cassandra is prepopulated
Changes made to the
system_auth
keyspace with
Al-
lowAllAuthorizer
enabled will be ignored by Cassandra. Hence
changes made in step 3 will not be applied and Cassandra will popu-
late default settings as shown in step 2.
6.
Let's try to create a user:
create user normaluser with password 'normal';
create user normaluser;
Creating a user with
AllowAllAuthenticator
is not permit-
ted in Cassandra as you can see in
Figure 4-23
. However, as we saw
earlier, it is possible with
PasswordAuthenticator
.