Informix Error -3620: You do not have permission to write into this table.

Cause and resolution

You do not have permission to write into this table.

You do not have insert or update privilege for the table, so you cannot insert or update a column. Check with the owner of the table or the person who has Database Administrator (DBA) privilege for the database for the necessary permission.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3620 fires when the current account lacks insert or update privilege on a table it's trying to modify through a form — per the official guidance, without those privileges a column can't be inserted or updated.

The account lacks INSERT/UPDATE privilege on the table, per the official guidance — the direct, only cause.

Solutions / Resolution

Check with the table's owner or the database's DBA for the necessary permission, per the official guidance.

Examples

Granting the needed privileges

GRANT INSERT, UPDATE ON orders TO myaccount;

Diagnostic Checks

Check whether the account has INSERT/UPDATE privilege on the table, and request it from the owner or DBA if missing.

Related Errors / Related Topics

-3421 — "The joined field table.column cannot be selected by the current user." A related privilege error, about missing SELECT privilege on a joined column rather than missing INSERT/UPDATE privilege on the table being modified.
-3710 — "Permission not granted to allow update of table-name." The specific UPDATE half of this same general write-privilege restriction.
-3720 — "Permission not granted to allow add of table-name." The specific INSERT half of this same general write-privilege restriction.

The account lacks INSERT/UPDATE privilege on the table — request it from the owner or DBA.