Revision 6716
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 908 | 908 |
DROP TABLE IF EXISTS analytical_aggregate; |
| 909 | 909 |
CREATE TABLE analytical_aggregate AS SELECT * FROM analytical_aggregate_view LIMIT 0; |
| 910 | 910 |
|
| 911 |
GRANT SELECT ON TABLE analytical_aggregate TO bien_read; |
|
| 912 |
|
|
| 911 | 913 |
ALTER TABLE analytical_aggregate ALTER COLUMN "institutionCode" SET NOT NULL; |
| 912 | 914 |
ALTER TABLE analytical_aggregate ALTER COLUMN "locationName" SET NOT NULL; |
| 913 | 915 |
|
| ... | ... | |
| 925 | 927 |
DROP TABLE IF EXISTS analytical_stem; |
| 926 | 928 |
CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view LIMIT 0; |
| 927 | 929 |
|
| 930 |
GRANT SELECT ON TABLE analytical_stem TO bien_read; |
|
| 931 |
|
|
| 928 | 932 |
ALTER TABLE analytical_stem ALTER COLUMN "institutionCode" SET NOT NULL; |
| 929 | 933 |
ALTER TABLE analytical_stem ALTER COLUMN "locationName" SET NOT NULL; |
| 930 | 934 |
|
| ... | ... | |
| 943 | 947 |
AS $$ |
| 944 | 948 |
DROP TABLE IF EXISTS geoscrub_input; |
| 945 | 949 |
CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view; |
| 950 |
|
|
| 951 |
GRANT SELECT ON TABLE geoscrub_input TO bien_read; |
|
| 946 | 952 |
$$; |
| 947 | 953 |
|
| 948 | 954 |
|
Also available in: Unified diff
schemas/vegbien.sql: sync_*_to_view(): Added `GRANT SELECT TO bien_read`