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;