doc/modules/cassandra/examples/CQL/alter_user.cql

ALTER USER alice WITH PASSWORD 'PASSWORD_A';
ALTER USER bob SUPERUSER;