Using INSERT … SELECT With Tables That Have Row‑Level Security
You can use INSERT … SELECT requests with tables that have row‑level security if all
the tables have exactly the same row‑level security constraints.
Note: Teradata Database does not execute the security policy UDF for row-level security
constraints on the target table.
If the session executing the request does not have the appropriate OVERRIDE privilege
to use the DML statement on the target table, Teradata Database takes the values for
all row-level security constraint columns from the source table.
If the session has the appropriate OVERRIDE privilege, Teradata Database takes the
constraint values from the source table unless they are provided as part of the INSERT … SELECT
request.