From 83337b19b6825733b001b342deebffe811c2b465 Mon Sep 17 00:00:00 2001 From: rubyonrials Date: Wed, 19 Jun 2019 11:58:30 -0700 Subject: [PATCH] fix permission documentation issue existing postgres-permissions documentation led to an error. there is a commented out section in the same file that includes the fix ("GRANT USAGE ON SCHEMA" is required). fix documentation to avoid the error. (fix #2404) --- docs/graphql/manual/deployment/postgres-permissions.rst | 1 + 1 file changed, 1 insertion(+) diff --git a/docs/graphql/manual/deployment/postgres-permissions.rst b/docs/graphql/manual/deployment/postgres-permissions.rst index de33adf433f9e..f2983b44c07b5 100644 --- a/docs/graphql/manual/deployment/postgres-permissions.rst +++ b/docs/graphql/manual/deployment/postgres-permissions.rst @@ -57,6 +57,7 @@ Here's a sample SQL block that you can run on your database to create the right -- grant all privileges on all tables in the public schema. This can be customised: -- For example, if you only want to use GraphQL regular queries and not mutations, -- then you can set: GRANT SELECT ON ALL TABLES... + GRANT USAGE ON SCHEMA public TO hasurauser; GRANT ALL ON ALL TABLES IN SCHEMA public TO hasurauser; GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO hasurauser;