Privileges | Geospatial Data Types | Teradata Vantage - 17.05 - Privileges - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1181-170K

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;