15.00 - 9447 Override Insert Constraint privilege is required for specifying a value for constraint column '%FLDID'. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9447 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.

Remedy:

Replace the user-specified value for the constraint