Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[feat]: Roles - List Permissions (users and roles) in tree and make searchable in tree search #681

Open
millerjp opened this issue Jan 2, 2025 · 0 comments
Assignees
Labels
enhancement New feature or request right click
Milestone

Comments

@millerjp
Copy link
Contributor

millerjp commented Jan 2, 2025

We need to add a new grouping under the cluster called "Permissions" to handle users and roles in the . We will start adding roles and users under there and searchable on the tree search

Permissions should not automaticaly be populated in the tree as its ultimately querying the system_auth keyspace to build this up and it could be a heavy set of queries to bring it back. Also, do not autatically repopulate this when refreshing the tree following schema changes. Just add a refresh icon next to Permissions and then populate this.

-- Cluster: mycluster
-- Keyspaces
-- Permissions (with a refresh icon next to this)
   |- Users (4)
      |- Standard (3)
         |- User 1
         |- User 2
         |- User 3
      |- Super Users (2)
         |- cassndra
         |- mydba
   |- Roles (3)
     |- Role 1
     |- Role 2
     |- Role 3

The CQL below will return all USERS and ROLES in Cassandra

LIST ROLES;

1 - To find standard users, you find roles where login is true and super is false

2 - To find super users, you find roles where login is true and super is true

3 - To find roles, you find roles where login is false and super is false

Make sure to test:
1 - When connected as a super user
2 - When connected as a standard user
3 - When connected without authentication
4 - When 100s of roles and users

@millerjp millerjp added enhancement New feature or request right click labels Jan 2, 2025
@millerjp millerjp added this to the RightClick milestone Jan 2, 2025
@millerjp millerjp changed the title [feat]: Roles - List Users and Roles in tree [feat]: Roles - List Permissions (users and roles) in tree Jan 2, 2025
@millerjp millerjp changed the title [feat]: Roles - List Permissions (users and roles) in tree [feat]: Roles - List Permissions (users and roles) in tree and make searchable in tree search Jan 2, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request right click
Projects
None yet
Development

No branches or pull requests

2 participants