Teradata Database Message 9447 - 9447 - Analytics Database - Teradata Vantage

Message

Override Insert Constraint privilege is required for specifying a value for constraint column '%FLDID'.

Explanation

The user has does not have Override Insert Constraint privilege on a constraint column and has either: 1) specified a value for the column, or 2) submitted a compound statement (INSERT-SELECT or MERGE-INTO) and the insert values for the column were not taken directly from the source table. Without Override Insert Constraint privilege, a MERGE INTO with an INSERT component can only reference the source base table in the USING clause, and not a view or derived table based on the source table.

Generated By

Resolver.

For Whom

End User.

Notes

None

Remedy

Replace the user-specified value for the constraint