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
I see the list is different when queried list roles and system_auth.roles
@vijayshanker.oracle_94842 The 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.
DataStax Enterprise is powered by the best distribution of Apache Cassandra ™
© 2022 DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.
Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, 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.
Privacy Policy Terms of Use