Informix Error -3710: Permission not granted to allow update of table-name.

Cause and resolution

Permission not granted to allow update of table-name.

Your account has not been granted UPDATE privilege for the table table-name. The owner of the table, or a person who has Database Administrator (DBA) privilege for the database, can grant this privilege level to you.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3710 fires when the current account lacks UPDATE privilege on table-name — per the official guidance, the table's owner or a DBA can grant this privilege.

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

Solutions / Resolution

Have the table's owner or a Database Administrator grant UPDATE privilege, per the official guidance.

Examples

Granting UPDATE privilege

GRANT UPDATE ON table-name TO myaccount;

Diagnostic Checks

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

Related Errors / Related Topics

-3620 — "You do not have permission to write into this table." A closely related write-privilege error, about INSERT/UPDATE privilege together rather than UPDATE specifically.
-3700 — "Permission not granted to allow reading of table-name." The equivalent privilege check for SELECT rather than UPDATE.
-3720 — "Permission not granted to allow add of table-name." The equivalent privilege check for INSERT rather than UPDATE.

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