Grant Permissions - Geospatial Utilities

Teradata Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2020-02-25
dita:mapPath
gwb1527114222318.ditamap
dita:ditavalPath
Audience_PDF_include.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