I see the list is different when queried list roles and system_auth.roles
Bringing together the Apache Cassandra experts from the community and DataStax.
Want to learn? Have a question? Want to share your expertise? You are in the right place!
Not sure where to begin? Getting Started
LIST ROLES command displays the roles that the current authenticated role has permissions to display. For example, a non-superuser role will only be able to list a limited set of roles since it doesn't have permissions to view superuser roles.
On the other hand, typically only superuser roles can view the contents of the
system_auth.roles table unless other roles have been granted
SELECT permissions. Cheers!
3 People are following this question.