Session Constraints and Bulk Table Loads | Teradata Vantage - About Session Constraints and Bulk Table Loads - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

By default, row inserts into RLS-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.