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

Teradata Vantage™ - Advanced SQL Engine 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
zuy1472246340572

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.