You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Shailaja Koppu (Jira)" <ji...@apache.org> on 2024/02/21 15:04:00 UTC
[jira] [Created] (CASSANDRA-19417) LIST SUPERUSERS cql command
Shailaja Koppu created CASSANDRA-19417:
------------------------------------------
Summary: 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
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