From 7145fec8107ed0f0c8360faf4b3d87f31abc67c7 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sat, 21 Oct 2023 14:00:56 +0100 Subject: Remove apache from DB grants --- gentoobrowse-api/db/schema.sql | 21 --------------------- 1 file changed, 21 deletions(-) diff --git a/gentoobrowse-api/db/schema.sql b/gentoobrowse-api/db/schema.sql index 9f6cce7..02b3338 100644 --- a/gentoobrowse-api/db/schema.sql +++ b/gentoobrowse-api/db/schema.sql @@ -773,106 +773,85 @@ ALTER TABLE ONLY user_packages -- Name: gentoobrowse; Type: ACL; Schema: -; Owner: gentoo REVOKE ALL ON SCHEMA gentoobrowse FROM PUBLIC; REVOKE ALL ON SCHEMA gentoobrowse FROM gentoo; -GRANT USAGE ON SCHEMA gentoobrowse TO apache; GRANT USAGE ON SCHEMA gentoobrowse TO gentoo; -- Name: bugs; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE bugs FROM PUBLIC; REVOKE ALL ON TABLE bugs FROM gentoo; GRANT ALL ON TABLE bugs TO gentoo; -GRANT SELECT ON TABLE bugs TO apache; -- Name: packages; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE packages FROM PUBLIC; REVOKE ALL ON TABLE packages FROM gentoo; GRANT ALL ON TABLE packages TO gentoo; -GRANT SELECT ON TABLE packages TO apache; -- Name: categories; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE categories FROM PUBLIC; REVOKE ALL ON TABLE categories FROM gentoo; GRANT ALL ON TABLE categories TO gentoo; -GRANT SELECT ON TABLE categories TO apache; -- Name: changelog; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE changelog FROM PUBLIC; REVOKE ALL ON TABLE changelog FROM gentoo; GRANT ALL ON TABLE changelog TO gentoo; -GRANT SELECT ON TABLE changelog TO apache; -- Name: ebuild_archs; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE ebuild_archs FROM PUBLIC; REVOKE ALL ON TABLE ebuild_archs FROM gentoo; GRANT ALL ON TABLE ebuild_archs TO gentoo; -GRANT SELECT ON TABLE ebuild_archs TO apache; -- Name: ebuild_deps; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE ebuild_deps FROM PUBLIC; REVOKE ALL ON TABLE ebuild_deps FROM gentoo; GRANT ALL ON TABLE ebuild_deps TO gentoo; -GRANT SELECT ON TABLE ebuild_deps TO apache; -- Name: ebuild_masks; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE ebuild_masks FROM PUBLIC; REVOKE ALL ON TABLE ebuild_masks FROM gentoo; GRANT ALL ON TABLE ebuild_masks TO gentoo; -GRANT SELECT ON TABLE ebuild_masks TO apache; -- Name: ebuild_rdeps; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE ebuild_rdeps FROM PUBLIC; REVOKE ALL ON TABLE ebuild_rdeps FROM gentoo; GRANT ALL ON TABLE ebuild_rdeps TO gentoo; -GRANT SELECT ON TABLE ebuild_rdeps TO apache; -- Name: ebuild_uses; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE ebuild_uses FROM PUBLIC; REVOKE ALL ON TABLE ebuild_uses FROM gentoo; GRANT ALL ON TABLE ebuild_uses TO gentoo; -GRANT SELECT ON TABLE ebuild_uses TO apache; -- Name: ebuilds; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE ebuilds FROM PUBLIC; REVOKE ALL ON TABLE ebuilds FROM gentoo; GRANT ALL ON TABLE ebuilds TO gentoo; -GRANT SELECT ON TABLE ebuilds TO apache; -- Name: masksets; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE masksets FROM PUBLIC; REVOKE ALL ON TABLE masksets FROM gentoo; GRANT ALL ON TABLE masksets TO gentoo; -GRANT SELECT ON TABLE masksets TO apache; -- Name: package_urls; Type: ACL; Schema: gentoobrowse; Owner: gentoo 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; GRANT ALL ON TABLE use_global TO gentoo; -GRANT SELECT ON TABLE use_global TO apache; -- Name: use_group; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE use_group FROM PUBLIC; REVOKE ALL ON TABLE use_group FROM gentoo; GRANT ALL ON TABLE use_group TO gentoo; -GRANT SELECT ON TABLE use_group TO apache; -- Name: use_groups; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE use_groups FROM PUBLIC; REVOKE ALL ON TABLE use_groups FROM gentoo; GRANT ALL ON TABLE use_groups TO gentoo; -GRANT SELECT ON TABLE use_groups TO apache; -- Name: use_local; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE use_local FROM PUBLIC; REVOKE ALL ON TABLE use_local FROM gentoo; GRANT ALL ON TABLE use_local TO gentoo; -GRANT SELECT ON TABLE use_local TO apache; -- Name: user_packages; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE user_packages FROM PUBLIC; REVOKE ALL ON TABLE user_packages FROM gentoo; GRANT ALL ON TABLE user_packages TO gentoo; -GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE user_packages TO apache; -- Name: users; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE users FROM PUBLIC; REVOKE ALL ON TABLE users FROM gentoo; GRANT ALL ON TABLE users TO gentoo; -GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE users TO apache; -- Name: users_userid_seq; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON SEQUENCE users_userid_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE users_userid_seq FROM gentoo; GRANT ALL ON SEQUENCE users_userid_seq TO gentoo; -GRANT ALL ON SEQUENCE users_userid_seq TO apache; -- PostgreSQL database dump complete -- cgit v1.2.3