DataStax Enterprise 3.0 Documentation

ALTER USER

This documentation corresponds to an earlier product version. Make sure this document corresponds to your version.

Latest DSE documentation | Earlier DSE documentation

Alter existing user options.

Synopsis

ALTER USER user_name
  WITH PASSWORD 'password' NOSUPERUSER | SUPERUSER

Synopsis legend

In the synopsis section of each statement, formatting has the following meaning:

  • Uppercase means literal
  • Lowercase means not literal
  • Italics mean optional
  • The pipe (|) symbol means OR or AND/OR
  • Ellipsis (...) means repeatable

A semicolon that terminates cqlsh statements is not included in the synopsis.

Description

Superusers can change a user's password or superuser status. To prevent disabling all superusers, superusers cannot change their own superuser status. Ordinary users can change only their own password.

Enclose the user name in single quotation marks if it contains non-alphanumeric characters. Enclose the password in single quotation marks.

Example

ALTER USER moss WITH PASSWORD 'bestReceiver';