Effective CQL - Mastering Apache Cassandra - page 149

LIST USERS
The LIST USERS command lists all the users in the system and their status. Note that
you must have authentication enabled and be logged in as a user to run the following
query. Here's an example:
cqlsh:demo_cql> LIST USERS;
name | super
-----------+-------
oracle | False
cassandra | True
testuser | False
(3 rows)
LIST PERMISSIONS
The LIST PERMISSIONS command lists all the permissions on an entity and the entit-
ies under it. The syntax is as follows:
LIST [ permission_name PERMISSION | ALL PERMISSIONS ]
[ ON { ALL KEYSPACES | KEYSPACE ks_name | TABLE
ks_name.table_name} ]
[ OF user_name ]
[ NORECURSIVE ]
Here, permission_name is the same as we have seen in GRANT . The entity name can
be the keyspace name or table name or all keyspaces. The username is one of the existing