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.