Revision 6341
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 7312 | 7312 |
|
| 7313 | 7313 |
|
| 7314 | 7314 |
-- |
| 7315 |
-- Name: place; Type: ACL; Schema: public; Owner: - |
|
| 7316 |
-- |
|
| 7317 |
|
|
| 7318 |
REVOKE ALL ON TABLE place FROM PUBLIC; |
|
| 7319 |
REVOKE ALL ON TABLE place FROM bien; |
|
| 7320 |
GRANT ALL ON TABLE place TO bien; |
|
| 7321 |
GRANT SELECT ON TABLE place TO bien_read; |
|
| 7322 |
|
|
| 7323 |
|
|
| 7324 |
-- |
|
| 7325 |
-- Name: taxonlabel; Type: ACL; Schema: public; Owner: - |
|
| 7326 |
-- |
|
| 7327 |
|
|
| 7328 |
REVOKE ALL ON TABLE taxonlabel FROM PUBLIC; |
|
| 7329 |
REVOKE ALL ON TABLE taxonlabel FROM bien; |
|
| 7330 |
GRANT ALL ON TABLE taxonlabel TO bien; |
|
| 7331 |
GRANT SELECT ON TABLE taxonlabel TO bien_read; |
|
| 7332 |
|
|
| 7333 |
|
|
| 7334 |
-- |
|
| 7335 |
-- Name: address; Type: ACL; Schema: public; Owner: - |
|
| 7336 |
-- |
|
| 7337 |
|
|
| 7338 |
REVOKE ALL ON TABLE address FROM PUBLIC; |
|
| 7339 |
REVOKE ALL ON TABLE address FROM bien; |
|
| 7340 |
GRANT ALL ON TABLE address TO bien; |
|
| 7341 |
GRANT SELECT ON TABLE address TO bien_read; |
|
| 7342 |
|
|
| 7343 |
|
|
| 7344 |
-- |
|
| 7345 |
-- Name: aggregateoccurrence; Type: ACL; Schema: public; Owner: - |
|
| 7346 |
-- |
|
| 7347 |
|
|
| 7348 |
REVOKE ALL ON TABLE aggregateoccurrence FROM PUBLIC; |
|
| 7349 |
REVOKE ALL ON TABLE aggregateoccurrence FROM bien; |
|
| 7350 |
GRANT ALL ON TABLE aggregateoccurrence TO bien; |
|
| 7351 |
GRANT SELECT ON TABLE aggregateoccurrence TO bien_read; |
|
| 7352 |
|
|
| 7353 |
|
|
| 7354 |
-- |
|
| 7315 | 7355 |
-- Name: analytical_aggregate; Type: ACL; Schema: public; Owner: - |
| 7316 | 7356 |
-- |
| 7317 | 7357 |
|
| ... | ... | |
| 7332 | 7372 |
|
| 7333 | 7373 |
|
| 7334 | 7374 |
-- |
| 7375 |
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: - |
|
| 7376 |
-- |
|
| 7377 |
|
|
| 7378 |
REVOKE ALL ON TABLE analytical_aggregate_view FROM PUBLIC; |
|
| 7379 |
REVOKE ALL ON TABLE analytical_aggregate_view FROM bien; |
|
| 7380 |
GRANT ALL ON TABLE analytical_aggregate_view TO bien; |
|
| 7381 |
GRANT SELECT ON TABLE analytical_aggregate_view TO bien_read; |
|
| 7382 |
|
|
| 7383 |
|
|
| 7384 |
-- |
|
| 7385 |
-- Name: coordinates; Type: ACL; Schema: public; Owner: - |
|
| 7386 |
-- |
|
| 7387 |
|
|
| 7388 |
REVOKE ALL ON TABLE coordinates FROM PUBLIC; |
|
| 7389 |
REVOKE ALL ON TABLE coordinates FROM bien; |
|
| 7390 |
GRANT ALL ON TABLE coordinates TO bien; |
|
| 7391 |
GRANT SELECT ON TABLE coordinates TO bien_read; |
|
| 7392 |
|
|
| 7393 |
|
|
| 7394 |
-- |
|
| 7395 |
-- Name: family_higher_plant_group; Type: ACL; Schema: public; Owner: - |
|
| 7396 |
-- |
|
| 7397 |
|
|
| 7398 |
REVOKE ALL ON TABLE family_higher_plant_group FROM PUBLIC; |
|
| 7399 |
REVOKE ALL ON TABLE family_higher_plant_group FROM bien; |
|
| 7400 |
GRANT ALL ON TABLE family_higher_plant_group TO bien; |
|
| 7401 |
GRANT SELECT ON TABLE family_higher_plant_group TO bien_read; |
|
| 7402 |
|
|
| 7403 |
|
|
| 7404 |
-- |
|
| 7405 |
-- Name: location; Type: ACL; Schema: public; Owner: - |
|
| 7406 |
-- |
|
| 7407 |
|
|
| 7408 |
REVOKE ALL ON TABLE location FROM PUBLIC; |
|
| 7409 |
REVOKE ALL ON TABLE location FROM bien; |
|
| 7410 |
GRANT ALL ON TABLE location TO bien; |
|
| 7411 |
GRANT SELECT ON TABLE location TO bien_read; |
|
| 7412 |
|
|
| 7413 |
|
|
| 7414 |
-- |
|
| 7415 |
-- Name: locationevent; Type: ACL; Schema: public; Owner: - |
|
| 7416 |
-- |
|
| 7417 |
|
|
| 7418 |
REVOKE ALL ON TABLE locationevent FROM PUBLIC; |
|
| 7419 |
REVOKE ALL ON TABLE locationevent FROM bien; |
|
| 7420 |
GRANT ALL ON TABLE locationevent TO bien; |
|
| 7421 |
GRANT SELECT ON TABLE locationevent TO bien_read; |
|
| 7422 |
|
|
| 7423 |
|
|
| 7424 |
-- |
|
| 7425 |
-- Name: locationplace; Type: ACL; Schema: public; Owner: - |
|
| 7426 |
-- |
|
| 7427 |
|
|
| 7428 |
REVOKE ALL ON TABLE locationplace FROM PUBLIC; |
|
| 7429 |
REVOKE ALL ON TABLE locationplace FROM bien; |
|
| 7430 |
GRANT ALL ON TABLE locationplace TO bien; |
|
| 7431 |
GRANT SELECT ON TABLE locationplace TO bien_read; |
|
| 7432 |
|
|
| 7433 |
|
|
| 7434 |
-- |
|
| 7435 |
-- Name: method; Type: ACL; Schema: public; Owner: - |
|
| 7436 |
-- |
|
| 7437 |
|
|
| 7438 |
REVOKE ALL ON TABLE method FROM PUBLIC; |
|
| 7439 |
REVOKE ALL ON TABLE method FROM bien; |
|
| 7440 |
GRANT ALL ON TABLE method TO bien; |
|
| 7441 |
GRANT SELECT ON TABLE method TO bien_read; |
|
| 7442 |
|
|
| 7443 |
|
|
| 7444 |
-- |
|
| 7445 |
-- Name: party; Type: ACL; Schema: public; Owner: - |
|
| 7446 |
-- |
|
| 7447 |
|
|
| 7448 |
REVOKE ALL ON TABLE party FROM PUBLIC; |
|
| 7449 |
REVOKE ALL ON TABLE party FROM bien; |
|
| 7450 |
GRANT ALL ON TABLE party TO bien; |
|
| 7451 |
GRANT SELECT ON TABLE party TO bien_read; |
|
| 7452 |
|
|
| 7453 |
|
|
| 7454 |
-- |
|
| 7455 |
-- Name: plantobservation; Type: ACL; Schema: public; Owner: - |
|
| 7456 |
-- |
|
| 7457 |
|
|
| 7458 |
REVOKE ALL ON TABLE plantobservation FROM PUBLIC; |
|
| 7459 |
REVOKE ALL ON TABLE plantobservation FROM bien; |
|
| 7460 |
GRANT ALL ON TABLE plantobservation TO bien; |
|
| 7461 |
GRANT SELECT ON TABLE plantobservation TO bien_read; |
|
| 7462 |
|
|
| 7463 |
|
|
| 7464 |
-- |
|
| 7465 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
|
| 7466 |
-- |
|
| 7467 |
|
|
| 7468 |
REVOKE ALL ON TABLE source FROM PUBLIC; |
|
| 7469 |
REVOKE ALL ON TABLE source FROM bien; |
|
| 7470 |
GRANT ALL ON TABLE source TO bien; |
|
| 7471 |
GRANT SELECT ON TABLE source TO bien_read; |
|
| 7472 |
|
|
| 7473 |
|
|
| 7474 |
-- |
|
| 7475 |
-- Name: stemobservation; Type: ACL; Schema: public; Owner: - |
|
| 7476 |
-- |
|
| 7477 |
|
|
| 7478 |
REVOKE ALL ON TABLE stemobservation FROM PUBLIC; |
|
| 7479 |
REVOKE ALL ON TABLE stemobservation FROM bien; |
|
| 7480 |
GRANT ALL ON TABLE stemobservation TO bien; |
|
| 7481 |
GRANT SELECT ON TABLE stemobservation TO bien_read; |
|
| 7482 |
|
|
| 7483 |
|
|
| 7484 |
-- |
|
| 7485 |
-- Name: taxondetermination; Type: ACL; Schema: public; Owner: - |
|
| 7486 |
-- |
|
| 7487 |
|
|
| 7488 |
REVOKE ALL ON TABLE taxondetermination FROM PUBLIC; |
|
| 7489 |
REVOKE ALL ON TABLE taxondetermination FROM bien; |
|
| 7490 |
GRANT ALL ON TABLE taxondetermination TO bien; |
|
| 7491 |
GRANT SELECT ON TABLE taxondetermination TO bien_read; |
|
| 7492 |
|
|
| 7493 |
|
|
| 7494 |
-- |
|
| 7495 |
-- Name: taxonoccurrence; Type: ACL; Schema: public; Owner: - |
|
| 7496 |
-- |
|
| 7497 |
|
|
| 7498 |
REVOKE ALL ON TABLE taxonoccurrence FROM PUBLIC; |
|
| 7499 |
REVOKE ALL ON TABLE taxonoccurrence FROM bien; |
|
| 7500 |
GRANT ALL ON TABLE taxonoccurrence TO bien; |
|
| 7501 |
GRANT SELECT ON TABLE taxonoccurrence TO bien_read; |
|
| 7502 |
|
|
| 7503 |
|
|
| 7504 |
-- |
|
| 7505 |
-- Name: taxonverbatim; Type: ACL; Schema: public; Owner: - |
|
| 7506 |
-- |
|
| 7507 |
|
|
| 7508 |
REVOKE ALL ON TABLE taxonverbatim FROM PUBLIC; |
|
| 7509 |
REVOKE ALL ON TABLE taxonverbatim FROM bien; |
|
| 7510 |
GRANT ALL ON TABLE taxonverbatim TO bien; |
|
| 7511 |
GRANT SELECT ON TABLE taxonverbatim TO bien_read; |
|
| 7512 |
|
|
| 7513 |
|
|
| 7514 |
-- |
|
| 7515 |
-- Name: threatened_taxonlabel; Type: ACL; Schema: public; Owner: - |
|
| 7516 |
-- |
|
| 7517 |
|
|
| 7518 |
REVOKE ALL ON TABLE threatened_taxonlabel FROM PUBLIC; |
|
| 7519 |
REVOKE ALL ON TABLE threatened_taxonlabel FROM bien; |
|
| 7520 |
GRANT ALL ON TABLE threatened_taxonlabel TO bien; |
|
| 7521 |
GRANT SELECT ON TABLE threatened_taxonlabel TO bien_read; |
|
| 7522 |
|
|
| 7523 |
|
|
| 7524 |
-- |
|
| 7525 |
-- Name: analytical_stem_view; Type: ACL; Schema: public; Owner: - |
|
| 7526 |
-- |
|
| 7527 |
|
|
| 7528 |
REVOKE ALL ON TABLE analytical_stem_view FROM PUBLIC; |
|
| 7529 |
REVOKE ALL ON TABLE analytical_stem_view FROM bien; |
|
| 7530 |
GRANT ALL ON TABLE analytical_stem_view TO bien; |
|
| 7531 |
GRANT SELECT ON TABLE analytical_stem_view TO bien_read; |
|
| 7532 |
|
|
| 7533 |
|
|
| 7534 |
-- |
|
| 7535 |
-- Name: classcontributor; Type: ACL; Schema: public; Owner: - |
|
| 7536 |
-- |
|
| 7537 |
|
|
| 7538 |
REVOKE ALL ON TABLE classcontributor FROM PUBLIC; |
|
| 7539 |
REVOKE ALL ON TABLE classcontributor FROM bien; |
|
| 7540 |
GRANT ALL ON TABLE classcontributor TO bien; |
|
| 7541 |
GRANT SELECT ON TABLE classcontributor TO bien_read; |
|
| 7542 |
|
|
| 7543 |
|
|
| 7544 |
-- |
|
| 7545 |
-- Name: commclass; Type: ACL; Schema: public; Owner: - |
|
| 7546 |
-- |
|
| 7547 |
|
|
| 7548 |
REVOKE ALL ON TABLE commclass FROM PUBLIC; |
|
| 7549 |
REVOKE ALL ON TABLE commclass FROM bien; |
|
| 7550 |
GRANT ALL ON TABLE commclass TO bien; |
|
| 7551 |
GRANT SELECT ON TABLE commclass TO bien_read; |
|
| 7552 |
|
|
| 7553 |
|
|
| 7554 |
-- |
|
| 7555 |
-- Name: commconcept; Type: ACL; Schema: public; Owner: - |
|
| 7556 |
-- |
|
| 7557 |
|
|
| 7558 |
REVOKE ALL ON TABLE commconcept FROM PUBLIC; |
|
| 7559 |
REVOKE ALL ON TABLE commconcept FROM bien; |
|
| 7560 |
GRANT ALL ON TABLE commconcept TO bien; |
|
| 7561 |
GRANT SELECT ON TABLE commconcept TO bien_read; |
|
| 7562 |
|
|
| 7563 |
|
|
| 7564 |
-- |
|
| 7565 |
-- Name: commcorrelation; Type: ACL; Schema: public; Owner: - |
|
| 7566 |
-- |
|
| 7567 |
|
|
| 7568 |
REVOKE ALL ON TABLE commcorrelation FROM PUBLIC; |
|
| 7569 |
REVOKE ALL ON TABLE commcorrelation FROM bien; |
|
| 7570 |
GRANT ALL ON TABLE commcorrelation TO bien; |
|
| 7571 |
GRANT SELECT ON TABLE commcorrelation TO bien_read; |
|
| 7572 |
|
|
| 7573 |
|
|
| 7574 |
-- |
|
| 7575 |
-- Name: commdetermination; Type: ACL; Schema: public; Owner: - |
|
| 7576 |
-- |
|
| 7577 |
|
|
| 7578 |
REVOKE ALL ON TABLE commdetermination FROM PUBLIC; |
|
| 7579 |
REVOKE ALL ON TABLE commdetermination FROM bien; |
|
| 7580 |
GRANT ALL ON TABLE commdetermination TO bien; |
|
| 7581 |
GRANT SELECT ON TABLE commdetermination TO bien_read; |
|
| 7582 |
|
|
| 7583 |
|
|
| 7584 |
-- |
|
| 7585 |
-- Name: commlineage; Type: ACL; Schema: public; Owner: - |
|
| 7586 |
-- |
|
| 7587 |
|
|
| 7588 |
REVOKE ALL ON TABLE commlineage FROM PUBLIC; |
|
| 7589 |
REVOKE ALL ON TABLE commlineage FROM bien; |
|
| 7590 |
GRANT ALL ON TABLE commlineage TO bien; |
|
| 7591 |
GRANT SELECT ON TABLE commlineage TO bien_read; |
|
| 7592 |
|
|
| 7593 |
|
|
| 7594 |
-- |
|
| 7595 |
-- Name: commname; Type: ACL; Schema: public; Owner: - |
|
| 7596 |
-- |
|
| 7597 |
|
|
| 7598 |
REVOKE ALL ON TABLE commname FROM PUBLIC; |
|
| 7599 |
REVOKE ALL ON TABLE commname FROM bien; |
|
| 7600 |
GRANT ALL ON TABLE commname TO bien; |
|
| 7601 |
GRANT SELECT ON TABLE commname TO bien_read; |
|
| 7602 |
|
|
| 7603 |
|
|
| 7604 |
-- |
|
| 7605 |
-- Name: commstatus; Type: ACL; Schema: public; Owner: - |
|
| 7606 |
-- |
|
| 7607 |
|
|
| 7608 |
REVOKE ALL ON TABLE commstatus FROM PUBLIC; |
|
| 7609 |
REVOKE ALL ON TABLE commstatus FROM bien; |
|
| 7610 |
GRANT ALL ON TABLE commstatus TO bien; |
|
| 7611 |
GRANT SELECT ON TABLE commstatus TO bien_read; |
|
| 7612 |
|
|
| 7613 |
|
|
| 7614 |
-- |
|
| 7615 |
-- Name: commusage; Type: ACL; Schema: public; Owner: - |
|
| 7616 |
-- |
|
| 7617 |
|
|
| 7618 |
REVOKE ALL ON TABLE commusage FROM PUBLIC; |
|
| 7619 |
REVOKE ALL ON TABLE commusage FROM bien; |
|
| 7620 |
GRANT ALL ON TABLE commusage TO bien; |
|
| 7621 |
GRANT SELECT ON TABLE commusage TO bien_read; |
|
| 7622 |
|
|
| 7623 |
|
|
| 7624 |
-- |
|
| 7625 |
-- Name: coverindex; Type: ACL; Schema: public; Owner: - |
|
| 7626 |
-- |
|
| 7627 |
|
|
| 7628 |
REVOKE ALL ON TABLE coverindex FROM PUBLIC; |
|
| 7629 |
REVOKE ALL ON TABLE coverindex FROM bien; |
|
| 7630 |
GRANT ALL ON TABLE coverindex TO bien; |
|
| 7631 |
GRANT SELECT ON TABLE coverindex TO bien_read; |
|
| 7632 |
|
|
| 7633 |
|
|
| 7634 |
-- |
|
| 7635 |
-- Name: covermethod; Type: ACL; Schema: public; Owner: - |
|
| 7636 |
-- |
|
| 7637 |
|
|
| 7638 |
REVOKE ALL ON TABLE covermethod FROM PUBLIC; |
|
| 7639 |
REVOKE ALL ON TABLE covermethod FROM bien; |
|
| 7640 |
GRANT ALL ON TABLE covermethod TO bien; |
|
| 7641 |
GRANT SELECT ON TABLE covermethod TO bien_read; |
|
| 7642 |
|
|
| 7643 |
|
|
| 7644 |
-- |
|
| 7645 |
-- Name: definedvalue; Type: ACL; Schema: public; Owner: - |
|
| 7646 |
-- |
|
| 7647 |
|
|
| 7648 |
REVOKE ALL ON TABLE definedvalue FROM PUBLIC; |
|
| 7649 |
REVOKE ALL ON TABLE definedvalue FROM bien; |
|
| 7650 |
GRANT ALL ON TABLE definedvalue TO bien; |
|
| 7651 |
GRANT SELECT ON TABLE definedvalue TO bien_read; |
|
| 7652 |
|
|
| 7653 |
|
|
| 7654 |
-- |
|
| 7655 |
-- Name: disturbanceobs; Type: ACL; Schema: public; Owner: - |
|
| 7656 |
-- |
|
| 7657 |
|
|
| 7658 |
REVOKE ALL ON TABLE disturbanceobs FROM PUBLIC; |
|
| 7659 |
REVOKE ALL ON TABLE disturbanceobs FROM bien; |
|
| 7660 |
GRANT ALL ON TABLE disturbanceobs TO bien; |
|
| 7661 |
GRANT SELECT ON TABLE disturbanceobs TO bien_read; |
|
| 7662 |
|
|
| 7663 |
|
|
| 7664 |
-- |
|
| 7665 |
-- Name: geoscrub_input; Type: ACL; Schema: public; Owner: - |
|
| 7666 |
-- |
|
| 7667 |
|
|
| 7668 |
REVOKE ALL ON TABLE geoscrub_input FROM PUBLIC; |
|
| 7669 |
REVOKE ALL ON TABLE geoscrub_input FROM bien; |
|
| 7670 |
GRANT ALL ON TABLE geoscrub_input TO bien; |
|
| 7671 |
GRANT SELECT ON TABLE geoscrub_input TO bien_read; |
|
| 7672 |
|
|
| 7673 |
|
|
| 7674 |
-- |
|
| 7675 |
-- Name: geoscrub_input_view; Type: ACL; Schema: public; Owner: - |
|
| 7676 |
-- |
|
| 7677 |
|
|
| 7678 |
REVOKE ALL ON TABLE geoscrub_input_view FROM PUBLIC; |
|
| 7679 |
REVOKE ALL ON TABLE geoscrub_input_view FROM bien; |
|
| 7680 |
GRANT ALL ON TABLE geoscrub_input_view TO bien; |
|
| 7681 |
GRANT SELECT ON TABLE geoscrub_input_view TO bien_read; |
|
| 7682 |
|
|
| 7683 |
|
|
| 7684 |
-- |
|
| 7685 |
-- Name: graphic; Type: ACL; Schema: public; Owner: - |
|
| 7686 |
-- |
|
| 7687 |
|
|
| 7688 |
REVOKE ALL ON TABLE graphic FROM PUBLIC; |
|
| 7689 |
REVOKE ALL ON TABLE graphic FROM bien; |
|
| 7690 |
GRANT ALL ON TABLE graphic TO bien; |
|
| 7691 |
GRANT SELECT ON TABLE graphic TO bien_read; |
|
| 7692 |
|
|
| 7693 |
|
|
| 7694 |
-- |
|
| 7695 |
-- Name: higher_plant_group_nodes; Type: ACL; Schema: public; Owner: - |
|
| 7696 |
-- |
|
| 7697 |
|
|
| 7698 |
REVOKE ALL ON TABLE higher_plant_group_nodes FROM PUBLIC; |
|
| 7699 |
REVOKE ALL ON TABLE higher_plant_group_nodes FROM bien; |
|
| 7700 |
GRANT ALL ON TABLE higher_plant_group_nodes TO bien; |
|
| 7701 |
GRANT SELECT ON TABLE higher_plant_group_nodes TO bien_read; |
|
| 7702 |
|
|
| 7703 |
|
|
| 7704 |
-- |
|
| 7705 |
-- Name: locationeventcontributor; Type: ACL; Schema: public; Owner: - |
|
| 7706 |
-- |
|
| 7707 |
|
|
| 7708 |
REVOKE ALL ON TABLE locationeventcontributor FROM PUBLIC; |
|
| 7709 |
REVOKE ALL ON TABLE locationeventcontributor FROM bien; |
|
| 7710 |
GRANT ALL ON TABLE locationeventcontributor TO bien; |
|
| 7711 |
GRANT SELECT ON TABLE locationeventcontributor TO bien_read; |
|
| 7712 |
|
|
| 7713 |
|
|
| 7714 |
-- |
|
| 7715 |
-- Name: locationeventsynonym; Type: ACL; Schema: public; Owner: - |
|
| 7716 |
-- |
|
| 7717 |
|
|
| 7718 |
REVOKE ALL ON TABLE locationeventsynonym FROM PUBLIC; |
|
| 7719 |
REVOKE ALL ON TABLE locationeventsynonym FROM bien; |
|
| 7720 |
GRANT ALL ON TABLE locationeventsynonym TO bien; |
|
| 7721 |
GRANT SELECT ON TABLE locationeventsynonym TO bien_read; |
|
| 7722 |
|
|
| 7723 |
|
|
| 7724 |
-- |
|
| 7725 |
-- Name: methodtaxonclass; Type: ACL; Schema: public; Owner: - |
|
| 7726 |
-- |
|
| 7727 |
|
|
| 7728 |
REVOKE ALL ON TABLE methodtaxonclass FROM PUBLIC; |
|
| 7729 |
REVOKE ALL ON TABLE methodtaxonclass FROM bien; |
|
| 7730 |
GRANT ALL ON TABLE methodtaxonclass TO bien; |
|
| 7731 |
GRANT SELECT ON TABLE methodtaxonclass TO bien_read; |
|
| 7732 |
|
|
| 7733 |
|
|
| 7734 |
-- |
|
| 7735 |
-- Name: note; Type: ACL; Schema: public; Owner: - |
|
| 7736 |
-- |
|
| 7737 |
|
|
| 7738 |
REVOKE ALL ON TABLE note FROM PUBLIC; |
|
| 7739 |
REVOKE ALL ON TABLE note FROM bien; |
|
| 7740 |
GRANT ALL ON TABLE note TO bien; |
|
| 7741 |
GRANT SELECT ON TABLE note TO bien_read; |
|
| 7742 |
|
|
| 7743 |
|
|
| 7744 |
-- |
|
| 7745 |
-- Name: notelink; Type: ACL; Schema: public; Owner: - |
|
| 7746 |
-- |
|
| 7747 |
|
|
| 7748 |
REVOKE ALL ON TABLE notelink FROM PUBLIC; |
|
| 7749 |
REVOKE ALL ON TABLE notelink FROM bien; |
|
| 7750 |
GRANT ALL ON TABLE notelink TO bien; |
|
| 7751 |
GRANT SELECT ON TABLE notelink TO bien_read; |
|
| 7752 |
|
|
| 7753 |
|
|
| 7754 |
-- |
|
| 7755 |
-- Name: partymember; Type: ACL; Schema: public; Owner: - |
|
| 7756 |
-- |
|
| 7757 |
|
|
| 7758 |
REVOKE ALL ON TABLE partymember FROM PUBLIC; |
|
| 7759 |
REVOKE ALL ON TABLE partymember FROM bien; |
|
| 7760 |
GRANT ALL ON TABLE partymember TO bien; |
|
| 7761 |
GRANT SELECT ON TABLE partymember TO bien_read; |
|
| 7762 |
|
|
| 7763 |
|
|
| 7764 |
-- |
|
| 7765 |
-- Name: placecorrelation; Type: ACL; Schema: public; Owner: - |
|
| 7766 |
-- |
|
| 7767 |
|
|
| 7768 |
REVOKE ALL ON TABLE placecorrelation FROM PUBLIC; |
|
| 7769 |
REVOKE ALL ON TABLE placecorrelation FROM bien; |
|
| 7770 |
GRANT ALL ON TABLE placecorrelation TO bien; |
|
| 7771 |
GRANT SELECT ON TABLE placecorrelation TO bien_read; |
|
| 7772 |
|
|
| 7773 |
|
|
| 7774 |
-- |
|
| 7775 |
-- Name: placename; Type: ACL; Schema: public; Owner: - |
|
| 7776 |
-- |
|
| 7777 |
|
|
| 7778 |
REVOKE ALL ON TABLE placename FROM PUBLIC; |
|
| 7779 |
REVOKE ALL ON TABLE placename FROM bien; |
|
| 7780 |
GRANT ALL ON TABLE placename TO bien; |
|
| 7781 |
GRANT SELECT ON TABLE placename TO bien_read; |
|
| 7782 |
|
|
| 7783 |
|
|
| 7784 |
-- |
|
| 7785 |
-- Name: placename_ancestor; Type: ACL; Schema: public; Owner: - |
|
| 7786 |
-- |
|
| 7787 |
|
|
| 7788 |
REVOKE ALL ON TABLE placename_ancestor FROM PUBLIC; |
|
| 7789 |
REVOKE ALL ON TABLE placename_ancestor FROM bien; |
|
| 7790 |
GRANT ALL ON TABLE placename_ancestor TO bien; |
|
| 7791 |
GRANT SELECT ON TABLE placename_ancestor TO bien_read; |
|
| 7792 |
|
|
| 7793 |
|
|
| 7794 |
-- |
|
| 7795 |
-- Name: plant; Type: ACL; Schema: public; Owner: - |
|
| 7796 |
-- |
|
| 7797 |
|
|
| 7798 |
REVOKE ALL ON TABLE plant FROM PUBLIC; |
|
| 7799 |
REVOKE ALL ON TABLE plant FROM bien; |
|
| 7800 |
GRANT ALL ON TABLE plant TO bien; |
|
| 7801 |
GRANT SELECT ON TABLE plant TO bien_read; |
|
| 7802 |
|
|
| 7803 |
|
|
| 7804 |
-- |
|
| 7805 |
-- Name: project; Type: ACL; Schema: public; Owner: - |
|
| 7806 |
-- |
|
| 7807 |
|
|
| 7808 |
REVOKE ALL ON TABLE project FROM PUBLIC; |
|
| 7809 |
REVOKE ALL ON TABLE project FROM bien; |
|
| 7810 |
GRANT ALL ON TABLE project TO bien; |
|
| 7811 |
GRANT SELECT ON TABLE project TO bien_read; |
|
| 7812 |
|
|
| 7813 |
|
|
| 7814 |
-- |
|
| 7815 |
-- Name: projectcontributor; Type: ACL; Schema: public; Owner: - |
|
| 7816 |
-- |
|
| 7817 |
|
|
| 7818 |
REVOKE ALL ON TABLE projectcontributor FROM PUBLIC; |
|
| 7819 |
REVOKE ALL ON TABLE projectcontributor FROM bien; |
|
| 7820 |
GRANT ALL ON TABLE projectcontributor TO bien; |
|
| 7821 |
GRANT SELECT ON TABLE projectcontributor TO bien_read; |
|
| 7822 |
|
|
| 7823 |
|
|
| 7824 |
-- |
|
| 7825 |
-- Name: revision; Type: ACL; Schema: public; Owner: - |
|
| 7826 |
-- |
|
| 7827 |
|
|
| 7828 |
REVOKE ALL ON TABLE revision FROM PUBLIC; |
|
| 7829 |
REVOKE ALL ON TABLE revision FROM bien; |
|
| 7830 |
GRANT ALL ON TABLE revision TO bien; |
|
| 7831 |
GRANT SELECT ON TABLE revision TO bien_read; |
|
| 7832 |
|
|
| 7833 |
|
|
| 7834 |
-- |
|
| 7835 |
-- Name: soilobs; Type: ACL; Schema: public; Owner: - |
|
| 7836 |
-- |
|
| 7837 |
|
|
| 7838 |
REVOKE ALL ON TABLE soilobs FROM PUBLIC; |
|
| 7839 |
REVOKE ALL ON TABLE soilobs FROM bien; |
|
| 7840 |
GRANT ALL ON TABLE soilobs TO bien; |
|
| 7841 |
GRANT SELECT ON TABLE soilobs TO bien_read; |
|
| 7842 |
|
|
| 7843 |
|
|
| 7844 |
-- |
|
| 7845 |
-- Name: soiltaxon; Type: ACL; Schema: public; Owner: - |
|
| 7846 |
-- |
|
| 7847 |
|
|
| 7848 |
REVOKE ALL ON TABLE soiltaxon FROM PUBLIC; |
|
| 7849 |
REVOKE ALL ON TABLE soiltaxon FROM bien; |
|
| 7850 |
GRANT ALL ON TABLE soiltaxon TO bien; |
|
| 7851 |
GRANT SELECT ON TABLE soiltaxon TO bien_read; |
|
| 7852 |
|
|
| 7853 |
|
|
| 7854 |
-- |
|
| 7855 |
-- Name: sourcecontributor; Type: ACL; Schema: public; Owner: - |
|
| 7856 |
-- |
|
| 7857 |
|
|
| 7858 |
REVOKE ALL ON TABLE sourcecontributor FROM PUBLIC; |
|
| 7859 |
REVOKE ALL ON TABLE sourcecontributor FROM bien; |
|
| 7860 |
GRANT ALL ON TABLE sourcecontributor TO bien; |
|
| 7861 |
GRANT SELECT ON TABLE sourcecontributor TO bien_read; |
|
| 7862 |
|
|
| 7863 |
|
|
| 7864 |
-- |
|
| 7865 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: - |
|
| 7866 |
-- |
|
| 7867 |
|
|
| 7868 |
REVOKE ALL ON TABLE sourcename FROM PUBLIC; |
|
| 7869 |
REVOKE ALL ON TABLE sourcename FROM bien; |
|
| 7870 |
GRANT ALL ON TABLE sourcename TO bien; |
|
| 7871 |
GRANT SELECT ON TABLE sourcename TO bien_read; |
|
| 7872 |
|
|
| 7873 |
|
|
| 7874 |
-- |
|
| 7875 |
-- Name: specimen; Type: ACL; Schema: public; Owner: - |
|
| 7876 |
-- |
|
| 7877 |
|
|
| 7878 |
REVOKE ALL ON TABLE specimen FROM PUBLIC; |
|
| 7879 |
REVOKE ALL ON TABLE specimen FROM bien; |
|
| 7880 |
GRANT ALL ON TABLE specimen TO bien; |
|
| 7881 |
GRANT SELECT ON TABLE specimen TO bien_read; |
|
| 7882 |
|
|
| 7883 |
|
|
| 7884 |
-- |
|
| 7885 |
-- Name: specimenreplicate; Type: ACL; Schema: public; Owner: - |
|
| 7886 |
-- |
|
| 7887 |
|
|
| 7888 |
REVOKE ALL ON TABLE specimenreplicate FROM PUBLIC; |
|
| 7889 |
REVOKE ALL ON TABLE specimenreplicate FROM bien; |
|
| 7890 |
GRANT ALL ON TABLE specimenreplicate TO bien; |
|
| 7891 |
GRANT SELECT ON TABLE specimenreplicate TO bien_read; |
|
| 7892 |
|
|
| 7893 |
|
|
| 7894 |
-- |
|
| 7895 |
-- Name: stratum; Type: ACL; Schema: public; Owner: - |
|
| 7896 |
-- |
|
| 7897 |
|
|
| 7898 |
REVOKE ALL ON TABLE stratum FROM PUBLIC; |
|
| 7899 |
REVOKE ALL ON TABLE stratum FROM bien; |
|
| 7900 |
GRANT ALL ON TABLE stratum TO bien; |
|
| 7901 |
GRANT SELECT ON TABLE stratum TO bien_read; |
|
| 7902 |
|
|
| 7903 |
|
|
| 7904 |
-- |
|
| 7905 |
-- Name: taxonalt; Type: ACL; Schema: public; Owner: - |
|
| 7906 |
-- |
|
| 7907 |
|
|
| 7908 |
REVOKE ALL ON TABLE taxonalt FROM PUBLIC; |
|
| 7909 |
REVOKE ALL ON TABLE taxonalt FROM bien; |
|
| 7910 |
GRANT ALL ON TABLE taxonalt TO bien; |
|
| 7911 |
GRANT SELECT ON TABLE taxonalt TO bien_read; |
|
| 7912 |
|
|
| 7913 |
|
|
| 7914 |
-- |
|
| 7915 |
-- Name: taxonconcept; Type: ACL; Schema: public; Owner: - |
|
| 7916 |
-- |
|
| 7917 |
|
|
| 7918 |
REVOKE ALL ON TABLE taxonconcept FROM PUBLIC; |
|
| 7919 |
REVOKE ALL ON TABLE taxonconcept FROM bien; |
|
| 7920 |
GRANT ALL ON TABLE taxonconcept TO bien; |
|
| 7921 |
GRANT SELECT ON TABLE taxonconcept TO bien_read; |
|
| 7922 |
|
|
| 7923 |
|
|
| 7924 |
-- |
|
| 7925 |
-- Name: taxoncorrelation; Type: ACL; Schema: public; Owner: - |
|
| 7926 |
-- |
|
| 7927 |
|
|
| 7928 |
REVOKE ALL ON TABLE taxoncorrelation FROM PUBLIC; |
|
| 7929 |
REVOKE ALL ON TABLE taxoncorrelation FROM bien; |
|
| 7930 |
GRANT ALL ON TABLE taxoncorrelation TO bien; |
|
| 7931 |
GRANT SELECT ON TABLE taxoncorrelation TO bien_read; |
|
| 7932 |
|
|
| 7933 |
|
|
| 7934 |
-- |
|
| 7935 |
-- Name: taxonlabel_relationship; Type: ACL; Schema: public; Owner: - |
|
| 7936 |
-- |
|
| 7937 |
|
|
| 7938 |
REVOKE ALL ON TABLE taxonlabel_relationship FROM PUBLIC; |
|
| 7939 |
REVOKE ALL ON TABLE taxonlabel_relationship FROM bien; |
|
| 7940 |
GRANT ALL ON TABLE taxonlabel_relationship TO bien; |
|
| 7941 |
GRANT SELECT ON TABLE taxonlabel_relationship TO bien_read; |
|
| 7942 |
|
|
| 7943 |
|
|
| 7944 |
-- |
|
| 7945 |
-- Name: taxonlineage; Type: ACL; Schema: public; Owner: - |
|
| 7946 |
-- |
|
| 7947 |
|
|
| 7948 |
REVOKE ALL ON TABLE taxonlineage FROM PUBLIC; |
|
| 7949 |
REVOKE ALL ON TABLE taxonlineage FROM bien; |
|
| 7950 |
GRANT ALL ON TABLE taxonlineage TO bien; |
|
| 7951 |
GRANT SELECT ON TABLE taxonlineage TO bien_read; |
|
| 7952 |
|
|
| 7953 |
|
|
| 7954 |
-- |
|
| 7955 |
-- Name: taxonstatus; Type: ACL; Schema: public; Owner: - |
|
| 7956 |
-- |
|
| 7957 |
|
|
| 7958 |
REVOKE ALL ON TABLE taxonstatus FROM PUBLIC; |
|
| 7959 |
REVOKE ALL ON TABLE taxonstatus FROM bien; |
|
| 7960 |
GRANT ALL ON TABLE taxonstatus TO bien; |
|
| 7961 |
GRANT SELECT ON TABLE taxonstatus TO bien_read; |
|
| 7962 |
|
|
| 7963 |
|
|
| 7964 |
-- |
|
| 7965 |
-- Name: telephone; Type: ACL; Schema: public; Owner: - |
|
| 7966 |
-- |
|
| 7967 |
|
|
| 7968 |
REVOKE ALL ON TABLE telephone FROM PUBLIC; |
|
| 7969 |
REVOKE ALL ON TABLE telephone FROM bien; |
|
| 7970 |
GRANT ALL ON TABLE telephone TO bien; |
|
| 7971 |
GRANT SELECT ON TABLE telephone TO bien_read; |
|
| 7972 |
|
|
| 7973 |
|
|
| 7974 |
-- |
|
| 7975 |
-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: - |
|
| 7976 |
-- |
|
| 7977 |
|
|
| 7978 |
REVOKE ALL ON TABLE threatened_taxonlabel_view FROM PUBLIC; |
|
| 7979 |
REVOKE ALL ON TABLE threatened_taxonlabel_view FROM bien; |
|
| 7980 |
GRANT ALL ON TABLE threatened_taxonlabel_view TO bien; |
|
| 7981 |
GRANT SELECT ON TABLE threatened_taxonlabel_view TO bien_read; |
|
| 7982 |
|
|
| 7983 |
|
|
| 7984 |
-- |
|
| 7985 |
-- Name: tnrs_input_name; Type: ACL; Schema: public; Owner: - |
|
| 7986 |
-- |
|
| 7987 |
|
|
| 7988 |
REVOKE ALL ON TABLE tnrs_input_name FROM PUBLIC; |
|
| 7989 |
REVOKE ALL ON TABLE tnrs_input_name FROM bien; |
|
| 7990 |
GRANT ALL ON TABLE tnrs_input_name TO bien; |
|
| 7991 |
GRANT SELECT ON TABLE tnrs_input_name TO bien_read; |
|
| 7992 |
|
|
| 7993 |
|
|
| 7994 |
-- |
|
| 7995 |
-- Name: trait; Type: ACL; Schema: public; Owner: - |
|
| 7996 |
-- |
|
| 7997 |
|
|
| 7998 |
REVOKE ALL ON TABLE trait FROM PUBLIC; |
|
| 7999 |
REVOKE ALL ON TABLE trait FROM bien; |
|
| 8000 |
GRANT ALL ON TABLE trait TO bien; |
|
| 8001 |
GRANT SELECT ON TABLE trait TO bien_read; |
|
| 8002 |
|
|
| 8003 |
|
|
| 8004 |
-- |
|
| 8005 |
-- Name: userdefined; Type: ACL; Schema: public; Owner: - |
|
| 8006 |
-- |
|
| 8007 |
|
|
| 8008 |
REVOKE ALL ON TABLE userdefined FROM PUBLIC; |
|
| 8009 |
REVOKE ALL ON TABLE userdefined FROM bien; |
|
| 8010 |
GRANT ALL ON TABLE userdefined TO bien; |
|
| 8011 |
GRANT SELECT ON TABLE userdefined TO bien_read; |
|
| 8012 |
|
|
| 8013 |
|
|
| 8014 |
-- |
|
| 8015 |
-- Name: voucher; Type: ACL; Schema: public; Owner: - |
|
| 8016 |
-- |
|
| 8017 |
|
|
| 8018 |
REVOKE ALL ON TABLE voucher FROM PUBLIC; |
|
| 8019 |
REVOKE ALL ON TABLE voucher FROM bien; |
|
| 8020 |
GRANT ALL ON TABLE voucher TO bien; |
|
| 8021 |
GRANT SELECT ON TABLE voucher TO bien_read; |
|
| 8022 |
|
|
| 8023 |
|
|
| 8024 |
-- |
|
| 7335 | 8025 |
-- PostgreSQL database dump complete |
| 7336 | 8026 |
-- |
| 7337 | 8027 |
|
Also available in: Unified diff
schemas/vegbien.sql: Allow bien_read to SELECT from all tables in the public schema