Before you can use the geospatial types, functions, metadata tables, and stored procedures, you must be granted certain privileges.
Consider a user named GeoUser. The following statements grant the correct privileges:
- GRANT UDTUSAGE ON SYSUDTLIB TO GeoUser;
- GRANT EXECUTE FUNCTION ON SYSSPATIAL TO GeoUser;
- GRANT SELECT ON SYSSPATIAL TO GeoUser;
- GRANT EXECUTE PROCEDURE ON SYSSPATIAL TO GeoUser;