17.10 - Compound Statement SQL Requirements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

Compound statement SQL requests (such as INSERT ... SELECT, MERGE ... INTO, or ALTER TABLE ... INSERT INTO) are supported for row level security tables only if all tables in the statement include the same security constraint columns.

The security constraint UDFs do not execute for security constraints in the target table, only for those in the source table.

When the system generates security constraint values for the target table:

  • If the user does not have the OVERRIDE privilege for the operation on the table, the values for all constraint columns are taken from the corresponding columns of the source table.
  • If the user has the OVERRIDE privilege for the operation, the constraint values are taken from the source table, unless an alternate value is provided by the request.