Geospatial Types | Privileges Needed for DB Administration | Teradata Vantage - Geospatial Data Types - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantageā„¢
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;