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

ALTER ROLE bob WITH PASSWORD = 'PASSWORD_B' AND SUPERUSER = false;