Prepare user privileges and the violations table
You must make sure that the user who runs a load job has sufficient privileges to manage the constraints and the violations table.
The following table summarizes the actions that you must take.
The following sections discuss these actions in more detail.
| Table Status | User Privileges | Action |
|---|---|---|
| Owned by user | No further action is required. | |
| Not owned by user | User has DBA privileges on the table. | No further action is required. |
| Not owned by user | User does not have DBA privileges on the table. | User must have:
|
For detailed information about user privileges and violations tables, see the HCL Informix® Guide to SQL: Syntax and the HCL Informix Guide to SQL: Reference.