LIST USERS (Deprecated)

Lists internally authenticated users, created users with the command CREATE USER, and have not yet changed the default user.

LIST USERS is supported for backwards compatibility. Authentication and authorization for DataStax Enterprise (DSE) 5.0 and later are based on ROLES, and LIST ROLES should be used.

Synopsis

LIST USERS ;

Example

List the current users:

LIST USERS;

Output is:

 name      | super
-----------+-------
 cassandra |  True
     boone | False
     akers |  True
  spillman | False

Was this helpful?

Give Feedback

How can we improve the documentation?

© Copyright IBM Corporation 2026 | Privacy policy | Terms of use |  Manage Privacy Choices

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: Contact IBM