Privileges - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Geospatial Data Types

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K

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;