DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

vijayshanker.oracle_94842 avatar image
vijayshanker.oracle_94842 asked ·

What is the difference between LIST ROLES output and the system_auth.roles table?

I see the list is different when queried list roles and system_auth.roles

roles
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

@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!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.