Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-19417

LIST SUPERUSERS cql command

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 5.1
    • Tool/cqlsh

    Description

      Developing a new CQL command LIST SUPERUSERS to return list of roles with superuser privilege. This includes roles who acquired superuser privilege in the hierarchy. 

      Context: LIST ROLES cql command lists roles, their membership details and displays super=true for immediate superusers. But there can be roles who acquired superuser privilege due to a grant. LIST ROLES command won't display super=true for such roles and the only way to recognize such roles is to look for atleast one row with super=true in the output of LIST ROLES OF <role name> command. While this works to check is a given role has superuser privilege, there may be services (for example, Sidecar) working with C* and may need to maintain list of roles with superuser privilege. There is no existing command/tool to retrieve such roles details. Hence developing this command which returns all roles having superuser privilege.

      Attachments

        1. result_details.tar.gz
          40.45 MB
          Shailaja Koppu
        2. ci_summary.html
          7 kB
          Shailaja Koppu
        3. checkstyle_output.txt
          2 kB
          Shailaja Koppu

        Issue Links

          Activity

            People

              skoppu Shailaja Koppu
              skoppu Shailaja Koppu
              Shailaja Koppu
              Benjamin Lerer, Maxwell Guo, Stefan Miklosovic
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4.5h
                  4.5h