Remove apache from DB grants

1 files changed, 0 insertions, 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