Project

General

Profile

« Previous | Next » 

Revision 6340

schemas/vegbien.sql: Allow bien_read to SELECT from analytical_aggregate, analytical_stem

View differences:

vegbien.sql
7302 7302

  
7303 7303

  
7304 7304
--
7305
-- Name: public; Type: ACL; Schema: -; Owner: -
7306
--
7307

  
7308
REVOKE ALL ON SCHEMA public FROM PUBLIC;
7309
REVOKE ALL ON SCHEMA public FROM bien;
7310
GRANT ALL ON SCHEMA public TO bien;
7311
GRANT USAGE ON SCHEMA public TO bien_read;
7312

  
7313

  
7314
--
7315
-- Name: analytical_aggregate; Type: ACL; Schema: public; Owner: -
7316
--
7317

  
7318
REVOKE ALL ON TABLE analytical_aggregate FROM PUBLIC;
7319
REVOKE ALL ON TABLE analytical_aggregate FROM bien;
7320
GRANT ALL ON TABLE analytical_aggregate TO bien;
7321
GRANT SELECT ON TABLE analytical_aggregate TO bien_read;
7322

  
7323

  
7324
--
7325
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
7326
--
7327

  
7328
REVOKE ALL ON TABLE analytical_stem FROM PUBLIC;
7329
REVOKE ALL ON TABLE analytical_stem FROM bien;
7330
GRANT ALL ON TABLE analytical_stem TO bien;
7331
GRANT SELECT ON TABLE analytical_stem TO bien_read;
7332

  
7333

  
7334
--
7305 7335
-- PostgreSQL database dump complete
7306 7336
--
7307 7337

  

Also available in: Unified diff