Grant Permissions - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
oww1544831946763.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2519
lifecycle
previous
Product Category
Teradata Tools and Utilities

Grant the user permissions on sysudtlib and sysspatial:

create user geouser as perm=1e9 password=geouser;
grant all on dbc to geouser with grant option;
grant all on sysudtlib to geouser with grant option;
grant all on sysspatial to geouser with grant option;

The following figure shows the permissions required for a user of ST_Geometry column.

Grant Permissions Using BTEQ Example