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
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
zuy1472246340572

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.