Informix Error -32137: No Alter privilege to modify a constraint.
Cause and resolution
No Alter privilege to modify a constraint.
Alter privilege on the table is required to modify a constraint.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-32137 fires when a session without Alter privilege attempts to modify a constraint — per the official guidance.
- The session lacks Alter privilege on the table, per the official guidance — the direct, only cause.
Solutions / Resolution
- Obtain Alter privilege on the table, per the official guidance, before modifying the constraint.
Examples
N/A
No specific triggering statement is documented beyond a missing Alter privilege.
Diagnostic Checks
- Confirm whether the session holds Alter privilege on the target table, and request it if missing.
Related Errors / Related Topics
- -32116 — "Illegal session level for altering a constraint." A related constraint-modification error, on a session-level/table-level mismatch rather than a missing privilege.
A session without Alter privilege tried to modify a constraint — obtain Alter privilege on the table.