 
 
 --
--- Name: deprecated_dz_pv_readings_without_pv_service_point_ids; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE deprecated_dz_pv_readings_without_pv_service_point_ids FROM PUBLIC;
-REVOKE ALL ON TABLE deprecated_dz_pv_readings_without_pv_service_point_ids FROM postgres;
-GRANT ALL ON TABLE deprecated_dz_pv_readings_without_pv_service_point_ids TO postgres;
-GRANT ALL ON TABLE deprecated_dz_pv_readings_without_pv_service_point_ids TO sepgroup;
-GRANT SELECT ON TABLE deprecated_dz_pv_readings_without_pv_service_point_ids TO sepgroupreadonly;
-
-
---
--- Name: deprecated_meter_ids_for_houses_without_pv; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE deprecated_meter_ids_for_houses_without_pv FROM PUBLIC;
-REVOKE ALL ON TABLE deprecated_meter_ids_for_houses_without_pv FROM postgres;
-GRANT ALL ON TABLE deprecated_meter_ids_for_houses_without_pv TO postgres;
-GRANT ALL ON TABLE deprecated_meter_ids_for_houses_without_pv TO sepgroup;
-GRANT SELECT ON TABLE deprecated_meter_ids_for_houses_without_pv TO sepgroupreadonly;
-
-
---
--- Name: deprecated_nonpv_service_point_ids; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE deprecated_nonpv_service_point_ids FROM PUBLIC;
-REVOKE ALL ON TABLE deprecated_nonpv_service_point_ids FROM postgres;
-GRANT ALL ON TABLE deprecated_nonpv_service_point_ids TO postgres;
-GRANT ALL ON TABLE deprecated_nonpv_service_point_ids TO sepgroup;
-GRANT SELECT ON TABLE deprecated_nonpv_service_point_ids TO sepgroupreadonly;
-
-
---
--- Name: dz_energy_voltages_for_houses_without_pv; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE dz_energy_voltages_for_houses_without_pv FROM PUBLIC;
-REVOKE ALL ON TABLE dz_energy_voltages_for_houses_without_pv FROM postgres;
-GRANT ALL ON TABLE dz_energy_voltages_for_houses_without_pv TO postgres;
-GRANT ALL ON TABLE dz_energy_voltages_for_houses_without_pv TO sepgroup;
-GRANT SELECT ON TABLE dz_energy_voltages_for_houses_without_pv TO sepgroupreadonly;
-
-
---
--- Name: dz_monthly_energy_summary_double_pv_meter; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE dz_monthly_energy_summary_double_pv_meter FROM PUBLIC;
-REVOKE ALL ON TABLE dz_monthly_energy_summary_double_pv_meter FROM postgres;
-GRANT ALL ON TABLE dz_monthly_energy_summary_double_pv_meter TO postgres;
-GRANT ALL ON TABLE dz_monthly_energy_summary_double_pv_meter TO sepgroup;
-GRANT SELECT ON TABLE dz_monthly_energy_summary_double_pv_meter TO sepgroupreadonly;
-
-
---
--- Name: nonpv_service_point_ids; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE nonpv_service_point_ids FROM PUBLIC;
-REVOKE ALL ON TABLE nonpv_service_point_ids FROM postgres;
-GRANT ALL ON TABLE nonpv_service_point_ids TO postgres;
-GRANT ALL ON TABLE nonpv_service_point_ids TO sepgroup;
-GRANT SELECT ON TABLE nonpv_service_point_ids TO sepgroupreadonly;
-
-
---
--- Name: dz_monthly_energy_summary_for_nonpv_service_points; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE dz_monthly_energy_summary_for_nonpv_service_points FROM PUBLIC;
-REVOKE ALL ON TABLE dz_monthly_energy_summary_for_nonpv_service_points FROM postgres;
-GRANT ALL ON TABLE dz_monthly_energy_summary_for_nonpv_service_points TO postgres;
-GRANT ALL ON TABLE dz_monthly_energy_summary_for_nonpv_service_points TO sepgroup;
-GRANT SELECT ON TABLE dz_monthly_energy_summary_for_nonpv_service_points TO sepgroupreadonly;
-
-
---
--- Name: dz_monthly_energy_summary_single_pv_meter; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE dz_monthly_energy_summary_single_pv_meter FROM PUBLIC;
-REVOKE ALL ON TABLE dz_monthly_energy_summary_single_pv_meter FROM postgres;
-GRANT ALL ON TABLE dz_monthly_energy_summary_single_pv_meter TO postgres;
-GRANT ALL ON TABLE dz_monthly_energy_summary_single_pv_meter TO sepgroup;
-GRANT SELECT ON TABLE dz_monthly_energy_summary_single_pv_meter TO sepgroupreadonly;
-
-
---
 -- Name: dz_pv_interval_ids; Type: ACL; Schema: public; Owner: postgres
 --
 


REVOKE ALL ON TABLE cd_meter_ids_for_houses_with_pv_with_locations FROM PUBLIC;
REVOKE ALL ON TABLE cd_meter_ids_for_houses_with_pv_with_locations FROM eileen;
GRANT ALL ON TABLE cd_meter_ids_for_houses_with_pv_with_locations TO eileen;
GRANT ALL ON TABLE cd_meter_ids_for_houses_with_pv_with_locations TO sepgroup;
GRANT SELECT ON TABLE cd_meter_ids_for_houses_with_pv_with_locations TO sepgroupreadonly;





ALTER TABLE public."EgaugeEnergyAutoload" OWNER TO sepgroup;

--
-- Name: TABLE "EgaugeEnergyAutoload"; Type: COMMENT; Schema: public; Owner: sepgroup
--

COMMENT ON TABLE "EgaugeEnergyAutoload" IS 'Data that is autoload by the MSG eGauge Service. @author Daniel Zhang (張道博)';


--
-- Name: Event; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
