Session Constraints and Bulk Table Loads | Teradata Vantage - Session Constraints and Bulk Table Loads - Teradata Vantage - Analytics Database

Security Administration

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-29
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantageā„¢

By default, row inserts into row level security-protected tables done by users with OVERRIDE privileges require values to be specified for the constraint columns. This prevents these users from doing bulk loads through client loaders because data is read from external files.

The system can be configured to allow a user with OVERRIDE privileges and non-null session constraints to perform simple and bulk inserts without explicitly specifying constraint values for the constraint columns.

To enable this functionality, contact the Teradata Support Center.