15.10 - Privileges - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

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;