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

Create admin user #1349

Open
altmannmarcelo opened this issue Aug 15, 2024 · 0 comments
Open

Create admin user #1349

altmannmarcelo opened this issue Aug 15, 2024 · 0 comments
Labels
Medium priority Created by Linear-GitHub Sync
Milestone

Comments

@altmannmarcelo
Copy link
Contributor

Description

There are some external tools such as ProxySQL/Grafana, that require fetching the status of Readyset, such as SHOW READYSET STATUS, SHOW CACHES, SHOW PROXIED QUERIES.

Currently we need to expose the application user(the one Readyset is configured to use to connect to upstream). This is not ideal. Some reasons:

  • This is a security issue - We need to expose the credentials of a user that can potentially change data in the underlining database into multiple systems.
  • Operation nightmare - Most organizations rotate their password in a certain cadence. Changing the password in ProxySQL scheduler, Grafana dashboards is error prone.

Admin user should be able to run all the commands from https://readyset.io/docs/reference/command-reference

Change in user-visible behavior

Requires documentation change

@altmannmarcelo altmannmarcelo added this to the v.38 milestone Aug 15, 2024
@altmannmarcelo altmannmarcelo added High priority Created by Linear-GitHub Sync Medium priority Created by Linear-GitHub Sync and removed High priority Created by Linear-GitHub Sync labels Aug 15, 2024
@altmannmarcelo altmannmarcelo modified the milestones: v.38, v.39 Aug 19, 2024
@altmannmarcelo altmannmarcelo modified the milestones: v.39, v.40, v.41 Aug 26, 2024
@altmannmarcelo altmannmarcelo modified the milestones: v.41, v.42 Sep 9, 2024
@altmannmarcelo altmannmarcelo modified the milestones: v.42, v.43, v.44 Sep 16, 2024
@altmannmarcelo altmannmarcelo modified the milestones: v.44, v.45 Sep 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Medium priority Created by Linear-GitHub Sync
Projects
None yet
Development

No branches or pull requests

1 participant