cassandra@cqlsh>; create role my_role with password='my_role' and login=true;
cassandra@cqlsh>; grant all on keyspace my_keyspace to my_role;
exit

cqlsh localhost -u my_role -p my_role

my_role@cqlsh>; use my_keyspace;
my_role@cqlsh:my_keyspace> create table employees(
               ...  employee_id int primary key,
               ...  first_name text,
               ...  salary decimal,
               ...  hire_date timestamp);
my_role@cqlsh:my_keyspace> insert into employees(employee_id, first_name, hire_date, salary) values (100,'first','2011-01-31 16:30:00',100.02);
my_role@cqlsh:my_keyspace> select * from employees;

 employee_id | first_name | hire_date                       | salary
-------------+------------+---------------------------------+--------
         100 |      first | 2011-01-31 16:30:00.000000+0000 | 100.02