Revision 6715
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 6475 | 6475 |
|
| 6476 | 6476 |
|
| 6477 | 6477 |
-- |
| 6478 |
-- Name: analytical_aggregate; Type: ACL; Schema: public; Owner: - |
|
| 6479 |
-- |
|
| 6480 |
|
|
| 6481 |
|
|
| 6482 |
|
|
| 6483 |
|
|
| 6484 |
|
|
| 6485 |
|
|
| 6486 |
|
|
| 6487 |
-- |
|
| 6488 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
| 6489 |
-- |
|
| 6490 |
|
|
| 6491 |
|
|
| 6492 |
|
|
| 6493 |
|
|
| 6494 |
|
|
| 6495 |
|
|
| 6496 |
|
|
| 6497 |
-- |
|
| 6478 | 6498 |
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: - |
| 6479 | 6499 |
-- |
| 6480 | 6500 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 7589 | 7589 |
|
| 7590 | 7590 |
|
| 7591 | 7591 |
-- |
| 7592 |
-- Name: analytical_aggregate; Type: ACL; Schema: public; Owner: - |
|
| 7593 |
-- |
|
| 7594 |
|
|
| 7595 |
REVOKE ALL ON TABLE analytical_aggregate FROM PUBLIC; |
|
| 7596 |
REVOKE ALL ON TABLE analytical_aggregate FROM bien; |
|
| 7597 |
GRANT ALL ON TABLE analytical_aggregate TO bien; |
|
| 7598 |
GRANT SELECT ON TABLE analytical_aggregate TO bien_read; |
|
| 7599 |
|
|
| 7600 |
|
|
| 7601 |
-- |
|
| 7602 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
| 7603 |
-- |
|
| 7604 |
|
|
| 7605 |
REVOKE ALL ON TABLE analytical_stem FROM PUBLIC; |
|
| 7606 |
REVOKE ALL ON TABLE analytical_stem FROM bien; |
|
| 7607 |
GRANT ALL ON TABLE analytical_stem TO bien; |
|
| 7608 |
GRANT SELECT ON TABLE analytical_stem TO bien_read; |
|
| 7609 |
|
|
| 7610 |
|
|
| 7611 |
-- |
|
| 7592 | 7612 |
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: - |
| 7593 | 7613 |
-- |
| 7594 | 7614 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Added back bien_read's SELECT permissions, which had gotten removed when the tables were re-synced to their views