Grant Permissions - Geospatial Utilities

Teradata Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2519
lifecycle
previous
Product Category
Teradata Tools and Utilities

Grant Permissions

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;

Figure 3 shows the permissions required for a user of ST_Geometry column.

Figure 3: Grant Permissions Using BTEQ Example