Details
-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
2.0
-
None
Description
In the scripts/sql/createHarvestDB.pgsql it assumes, that user netarchivesuite exists.
A lot of GRANT statement is for that user.
Even though it is not stated in the preamble of the script
GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE schemaversions TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE domains TO netarchivesuite; GRANT USAGE ON SEQUENCE domains_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE configurations TO netarchivesuite; GRANT USAGE ON SEQUENCE configurations_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE config_passwords TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE config_seedlists TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE seedlists TO netarchivesuite; GRANT USAGE ON SEQUENCE seedlists_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE passwords TO netarchivesuite; GRANT USAGE ON SEQUENCE passwords_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE ownerinfo TO netarchivesuite; GRANT USAGE ON SEQUENCE ownerinfo_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE historyinfo TO netarchivesuite; GRANT USAGE ON SEQUENCE historyinfo_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE harvestdefinitions TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE fullharvests TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE partialharvests TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE harvest_configs TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE schedules TO netarchivesuite; GRANT USAGE ON SEQUENCE schedules_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE ordertemplates TO netarchivesuite; GRANT USAGE ON SEQUENCE ordertemplates_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE jobs TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE job_configs TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE global_crawler_trap_lists TO netarchivesuite; GRANT USAGE ON SEQUENCE global_crawler_trap_list_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE global_crawler_trap_expressions TO netarchivesuite; GRANT USAGE ON SEQUENCE global_crawler_trap_expressions_id_seq TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE runningJobsHistory TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE runningJobsMonitor TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE frontierReportMonitor TO netarchivesuite; GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE harvestchannel TO netarchivesuite; GRANT USAGE ON SEQUENCE harvestchannel_id_seq TO netarchivesuite;