Skip to content

Provide a different postgres user for migrations #8339

Open
@nico1996it

Description

@nico1996it

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions