16.20 - Geospatial Data Types - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K
Action Privilege Required
Grant the use of geospatial data types with their associated functions, metadata tables, and procedures.
  • GRANT ALL ON SYSSPATIAL TO SYSSPATIAL WITH GRANT OPTION;
  • GRANT SELECT ON DBC to SYSSPATIAL WITH GRANT OPTION;
  • GRANT EXECUTE PROCEDURE ON SYSSPATIAL to DBC WITH GRANT OPTION;
  • GRANT UDTMETHOD ON SYSUDTLIB to SYSSPATIAL;
  • GRANT UDTTYPE ON SYSUDTLIB to SYSSPATIAL;
  • GRANT CREATE FUNCTION ON SYSUDTLIB to SYSSPATIAL;
Grant the use of the GeoSequence date type.
  • GRANT UDTUSAGE ON SYSUDTLIB TO geouser;
  • GRANT EXECUTE FUNCTION ON SYSSPATIAL TO geouser;
  • GRANT SELECT ON SYSPATIAL TO geouser;
  • GRANT EXECUTE PROCEDURE ON SYSPATIAL TO geouser;