jsonsql/general grant karttur (setup_db)
Add db users for handling connections to postgres db
The json command file general_grant_karttur_v090_sql.json is part of karttur’s GeoImagine project setup_db. Calling the json file will execute the following commands of the GeoImagine Framework.
{
"process": [
{
"processid": "grant",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"user": "karttur",
"command": [
"GRANT USAGE ON SCHEMA process TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA process TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA process TO karttur;",
"GRANT USAGE ON SCHEMA system TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA system TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA system TO karttur;",
"GRANT USAGE ON SCHEMA regions TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA regions TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA regions TO karttur;",
"GRANT USAGE ON SCHEMA userlocale TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA userlocale TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA userlocale TO karttur;",
"GRANT USAGE ON SCHEMA ancillary TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA ancillary TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA ancillary TO karttur;",
"GRANT USAGE ON SCHEMA landsat TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA landsat TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA landsat TO karttur;",
"GRANT USAGE ON SCHEMA modis TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA modis TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA modis TO karttur;",
"GRANT USAGE ON SCHEMA sentinel TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA sentinel TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA sentinel TO karttur;",
"GRANT USAGE ON SCHEMA smap TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA smap TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA smap TO karttur;",
"GRANT USAGE ON SCHEMA layout TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA layout TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA layout TO karttur;",
"GRANT USAGE ON SCHEMA climateindex TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA climateindex TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA climateindex TO karttur;",
"GRANT USAGE ON SCHEMA soilmoisture TO karttur;",
"GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA soilmoisture TO karttur;",
"GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA soilmoisture TO karttur;"
]
}
}
]
}