17.20 - Compound Statement SQL Requirements - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.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 run 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.