From ad26a0a19a9e1678153295c6677fbd121992d8ad Mon Sep 17 00:00:00 2001 From: Tirumarai Selvan A Date: Mon, 30 Mar 2020 13:08:00 +0530 Subject: [PATCH] add permissions for functions Since UDFs are commonly used with Hasura, adding docs to grant sample permissions for their access. --- 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 c891fa1a59ce0..17cc3491c40ff 100644 --- a/docs/graphql/manual/deployment/postgres-permissions.rst +++ b/docs/graphql/manual/deployment/postgres-permissions.rst @@ -66,6 +66,7 @@ Here's a sample SQL block that you can run on your database to create the right 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; + GRANT ALL ON ALL FUNCTIONS IN SCHEMA public TO hasurauser; -- Similarly add this for other schemas, if you have any. -- GRANT USAGE ON SCHEMA TO hasurauser;