Load/Export Utility Requirements - 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
2023-11-02
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™

Load utilities that support the creation of database target tables as part of the job script also support the definition of security constraint columns in the target tables. TPump error table and Acquisition error tables for MultiLoad/FastLoad are not protected. However, Application error tables for MultiLoad/FastLoad are protected.

If the user does not have OVERRIDE privileges on a constraint when inserting into or updating a table, constraint column values default to the session constraint values for the user.

Granting OVERRIDE privileges to a user prevents use of the corresponding row level security constraint UDFs, and allows the user to specify the constraint values.

Users with OVERRIDE privileges must specify the values for non-hierarchical constraint columns as hex code instead of numeric values. See Specifying Non-Hierarchical Constraint Values when Loading Tables.