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

Add a read-only user to postgres for grafana #140

Open
AiroPi opened this issue Mar 18, 2024 · 0 comments
Open

Add a read-only user to postgres for grafana #140

AiroPi opened this issue Mar 18, 2024 · 0 comments

Comments

@AiroPi
Copy link
Member

AiroPi commented Mar 18, 2024

Curenlty, Grafana use the same credentials than the bot to read data from PostgreSQL. However, this is not a good practice and not recommended, because it can execute SQL query that can unintentionally alter the datas.

Alembic can be used to create a new migration executing CREATE USER with only SELECT permissions.
The user could be named GRAFANA.

I don't know much about postgres users, but I can help if needed.

@AiroPi AiroPi converted this from a draft issue Mar 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Todo
Development

No branches or pull requests

1 participant