| 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 |
|
schemas/vegbien.sql: Allow bien_read to SELECT from all tables in the public schema