-- Name: provider_count_view; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW provider_count_view AS

    SELECT analytical_stem.datasource AS provider, count(*) AS count FROM analytical_stem GROUP BY analytical_stem.datasource;

--

-- Name: provider_count_view; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE provider_count_view FROM PUBLIC;

REVOKE ALL ON TABLE provider_count_view FROM bien;

GRANT ALL ON TABLE provider_count_view TO bien;

GRANT SELECT ON TABLE provider_count_view TO bien_read;

GRANT SELECT ON TABLE provider_count_view TO public_;

--