From 3d5705d573fccc947c3d3b2edd4fd1314f5f97a4 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sat, 8 Aug 2015 23:45:37 +0100 Subject: Grant select to apache --- gentoobrowse/datasources/schema.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql index 4eec710..161af0d 100644 --- a/gentoobrowse/datasources/schema.sql +++ b/gentoobrowse/datasources/schema.sql @@ -814,6 +814,11 @@ REVOKE ALL ON TABLE package_urls FROM PUBLIC; REVOKE ALL ON TABLE package_urls FROM gentoo; GRANT ALL ON TABLE package_urls TO gentoo; GRANT SELECT ON TABLE package_urls TO apache; +-- Name: repos; Type: ACL; Schema: gentoobrowse; Owner: gentoo +REVOKE ALL ON TABLE repos FROM PUBLIC; +REVOKE ALL ON TABLE repos FROM gentoo; +GRANT ALL ON TABLE repos TO gentoo; +GRANT SELECT ON TABLE repos TO apache; -- Name: use_global; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE use_global FROM PUBLIC; REVOKE ALL ON TABLE use_global FROM gentoo; -- cgit v1.2.3