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

Provide a different postgres user for migrations #8339

Open
nico1996it opened this issue Mar 17, 2022 · 1 comment
Open

Provide a different postgres user for migrations #8339

nico1996it opened this issue Mar 17, 2022 · 1 comment
Labels
c/cli Related to CLI c/migrations Related to migrations k/enhancement New feature or improve an existing feature t/product-platform

Comments

@nico1996it
Copy link

Is your proposal related to a problem?

I want to provide to Hasura a dedicated pg user that doesn't have full powers, for instance if I have some financial transactions stored in the database, nobody in the infrastructure has to be allowed to delete them, even if they manage to hack the hasura instance they would not be allowed to have full admin control on the database.
The issue is that just when it comes to migrations, hasura has to be able to edit everything in the database.

Describe the solution you'd like

When i apply a migration from the cli there is an option to provide the credentials of a pg user that is going to perform the migration.

Describe alternatives you've considered

I could use a different migration service but i'm fine with hasura

If the feature is approved, would you be willing to submit a PR?

Well, maybe

@nico1996it nico1996it added the k/enhancement New feature or improve an existing feature label Mar 17, 2022
@rikinsk rikinsk added c/migrations Related to migrations c/cli Related to CLI labels Mar 28, 2022
@jokester
Copy link

jokester commented Aug 6, 2022

In case you are ok with docker: we could use a one-shot hasura container to run migrations with a different HASURA_GRAPHQL_DATABASE_URL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c/cli Related to CLI c/migrations Related to migrations k/enhancement New feature or improve an existing feature t/product-platform
Projects
None yet
Development

No branches or pull requests

4 participants