User privileges for using ArcGIS with Teradata

As a Teradata administrator, you should create groups based on what users need to do in the database, grant privileges to the groups, and add the appropriate database users to each group.

The following table lists two groups of users who will connect from ArcGIS and the minimum privileges they require to query or create data.

Teradata grants SELECT privileges on system tables to PUBLIC by default. If you revoke those privileges, you must grant privileges to individual groups or users.

Type of user

Required privileges

Purpose

Data viewer

SELECT ON SYSSPATIAL.SPATIAL_REF_SYS

SELECT ON SYSSPATIAL.GEOMETRY_COLUMNS

SELECT ON DBC.TVM

Required to read ST_GEOMETRY metadata for spatial operations.

SELECT ON <table1>,<table2>, <tablen>

Allows data viewers to query data in specific tables.

UDTUSAGE ON SYSUDTLIB

Required to preview features.

Data creator

Data creators require the same privileges as data viewers, plus these additional privileges.

INSERT ON SYSSPATIAL.SPATIAL_REF_SYS

UPDATE ON SYSSPATIAL.GEOMETRY_COLUMNS

EXECUTE FUNCTION ON SYSSPATIAL

EXECUTE PROCEDURE ON SYSSPATIAL

Required to update ST_GEOMETRY metadata when creating or updating spatial data.

CREATE TABLE

DROP TABLE

Required to create tables and feature classes in the database.

Additional, optional privileges you may want to grant data creators are as follows:

Related Topics

2/5/2015