[jira] [Commented] (CASSANDRA-19417) LIST SUPERUSERS cql command

["Shailaja Koppu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-19417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824104#comment-17824104 ] 

Shailaja Koppu commented on CASSANDRA-19417:
--------------------------------------------

As there are no further comments on ML thread, continuing with PR for code changes.
[~smiklosovic] I have merged all commits into one.
[~maxwellguo] resolved your comments, as I merged all commits into one, you won't see a separate commit just resolving your comments.
I have also added doc for this new CQL command.

> LIST SUPERUSERS cql command
> ---------------------------
>
>                 Key: CASSANDRA-19417
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-19417
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Tool/cqlsh
>            Reporter: Shailaja Koppu
>            Assignee: Shailaja Koppu
>            Priority: Normal
>              Labels: CQL
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org