16.10 - Error Table Requirements - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.