graphile / graphile/graphile.github.io

Troubleshooting: "permission denied for sequence"

Open
#100 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
SCSS
Stars
27
Forks
126
PR merge metrics
No merged PRs in 30d

Description

Error: `permission denied for sequence labels_id_seq`

Reason: limited `insert` privileges on table means that the sequence cannot generate a new value.

Solution: Grant GraphQL the ability to use sequences in the exposed schema.

```sql
alter default privileges in schema app_public grant usage, select on sequences to app_visitor;
grant usage, select on all sequences in schema app_public to app_visitor;
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.