 REVOKE ALL ON SEQUENCE registerread_id_seq FROM PUBLIC;
 REVOKE ALL ON SEQUENCE registerread_id_seq FROM sepgroup;
 GRANT ALL ON SEQUENCE registerread_id_seq TO sepgroup;
-
-
---
--- Name: test_cast_channel; Type: ACL; Schema: public; Owner: postgres
---
-
-REVOKE ALL ON TABLE test_cast_channel FROM PUBLIC;
-REVOKE ALL ON TABLE test_cast_channel FROM postgres;
-GRANT ALL ON TABLE test_cast_channel TO postgres;
-GRANT ALL ON TABLE test_cast_channel TO sepgroup;
 
 
 --



--
-- Name: readings_for_houses_without_pv_with_locations; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW readings_for_houses_without_pv_with_locations 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 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.readings_for_houses_without_pv_with_locations OWNER TO postgres;

--
-- Name: register_id_seq; Type: SEQUENCE; Schema: public; Owner: sepgroup
--




--
-- Name: register_id_seq; Type: ACL; Schema: public; Owner: sepgroup
--

