Is there a way to get Cassandra Role statistics?

Author: Junaid

Originally Sourced from: https://stackoverflow.com/questions/72273938/is-there-a-way-to-get-cassandra-role-statistics

Authentication can be enabled on a Cassandra cluster using database roles. Recently, I landed into a situation where multiple roles were created for a Cassandra cluster running 3.11.x version, and I didn't have any easy way to figure out which role is actively used or not. Is there a way to get usage statistics of database roles in Cassandra 3.11.x versions?

Thanks.