 
 
 --
+-- Name: readings_by_meter_location_history; Type: ACL; Schema: public; Owner: postgres
+--
+
+REVOKE ALL ON TABLE readings_by_meter_location_history FROM PUBLIC;
+REVOKE ALL ON TABLE readings_by_meter_location_history FROM postgres;
+GRANT ALL ON TABLE readings_by_meter_location_history TO postgres;
+GRANT ALL ON TABLE readings_by_meter_location_history TO sepgroup;
+
+
+--
 -- Name: dz_energy_voltages_for_houses_without_pv; Type: ACL; Schema: public; Owner: postgres
 --
 

--

CREATE VIEW deprecated_readings_for_houses_without_pv AS
    SELECT meter_ids_for_houses_without_pv.device_util_id, view_readings_with_meter_id_unsorted.end_time, view_readings_with_meter_id_unsorted.channel, view_readings_with_meter_id_unsorted.raw_value, view_readings_with_meter_id_unsorted.value, view_readings_with_meter_id_unsorted.uom, view_readings_with_meter_id_unsorted.start_time, view_readings_with_meter_id_unsorted.ird_end_time FROM (meter_ids_for_houses_without_pv JOIN readings_with_meter_id_unfiltered view_readings_with_meter_id_unsorted ON (((meter_ids_for_houses_without_pv.device_util_id)::integer = (view_readings_with_meter_id_unsorted.meter_name)::integer)));


ALTER TABLE public.deprecated_readings_for_houses_without_pv OWNER TO postgres;



--
-- Name: deprecated_readings_by_meter_location_history; Type: ACL; Schema: public; Owner: daniel
--

REVOKE ALL ON TABLE deprecated_readings_by_meter_location_history FROM PUBLIC;
REVOKE ALL ON TABLE deprecated_readings_by_meter_location_history FROM daniel;
GRANT ALL ON TABLE deprecated_readings_by_meter_location_history TO daniel;
GRANT ALL ON TABLE deprecated_readings_by_meter_location_history TO sepgroup;


--
-- Name: meter_ids_for_houses_without_pv; Type: ACL; Schema: public; Owner: postgres
--

