Josh Birdwell
Josh Birdwell

Reputation: 745

Hasura permission denied for table on insert

I'm attempting to do an insert on a table in Hasura's UI. I am getting permission denied even though I'm executing the query inside the api-explorer.

          "error": {
            "exec_status": "FatalError",
            "hint": null,
            "message": "permission denied for table players",
            "status_code": "42501",
            "description": null
          },

My insert mutation:

mutation insert_players($objects: [players_insert_input!]!) {
  insert_players(objects: $objects, on_conflict: {
      constraint: players_pkey,
      update_columns: [
         ...
         accelRating 
         age 
         ...
      ]
    }) {
    returning {
      id
    }
  }
}

Upvotes: 0

Views: 1140

Answers (1)

Josh Birdwell
Josh Birdwell

Reputation: 745

Heroku row limit was hit on the hobby dev plan. This can be checked on the heroku postgres add-on.

enter image description here

See this answer for more detail: Heroku PG: Recover Write access revoked

Upvotes: 1

Related Questions