CREATE USER geotools AS perm = 1e6, password = geotools;
GRANT UDTTYPE ON SYSUDTLIB TO geotools;
GRANT UDTUSAGE ON SYSUDTLIB TO geotools;
GRANT EXECUTE FUNCTION ON SYSUDTLIB TO geotools;
GRANT EXECUTE FUNCTION ON SYSSPATIAL TO geotools;
GRANT EXECUTE PROCEDURE ON SYSSPATIAL TO geotools;
GRANT SELECT ON SYSSPATIAL TO geotools;
GRANT ALL ON SYSSPATIAL.GEOMETRY_COLUMNS TO geotools;
GRANT SELECT ON DBC TO geotools;
--INSERT INTO SYSSPATIAL.spatial_sys_ref (SRID, AUTH_NAME, AUTH_SRID, SRITEXT) VALUES (1619, 'EPSG', 4326, 'GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]')
