Revision 6340
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 6258 | 6258 |
|
| 6259 | 6259 |
|
| 6260 | 6260 |
-- |
| 6261 |
-- Name: public; Type: ACL; Schema: -; Owner: - |
|
| 6262 |
-- |
|
| 6263 |
|
|
| 6264 |
|
|
| 6265 |
|
|
| 6266 |
|
|
| 6267 |
|
|
| 6268 |
|
|
| 6269 |
|
|
| 6270 |
-- |
|
| 6271 |
-- Name: analytical_aggregate; Type: ACL; Schema: public; Owner: - |
|
| 6272 |
-- |
|
| 6273 |
|
|
| 6274 |
|
|
| 6275 |
|
|
| 6276 |
|
|
| 6277 |
|
|
| 6278 |
|
|
| 6279 |
|
|
| 6280 |
-- |
|
| 6281 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
| 6282 |
-- |
|
| 6283 |
|
|
| 6284 |
|
|
| 6285 |
|
|
| 6286 |
|
|
| 6287 |
|
|
| 6288 |
|
|
| 6289 |
|
|
| 6290 |
-- |
|
| 6261 | 6291 |
-- PostgreSQL database dump complete |
| 6262 | 6292 |
-- |
| 6263 | 6293 |
|
| schemas/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