Revision 6340
Added by Aaron Marcuse-Kubitza over 11 years ago
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
schemas/vegbien.sql: Allow bien_read to SELECT from analytical_aggregate, analytical_stem