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

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.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.