17.10 - Error Table Requirements - 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

When you use the CREATE ERROR TABLE statement, all security constraint columns in the base table are automatically added to the generated error table.

You can prevent the creation of constraints columns in error tables using the NO RLS clause.

When an error inserts rows into an error table, the system does not enforce row level security constraints because they are already enforced on the base table during the execution of the MERGE INTO or INSERT ... SELECT operation that generated the error.