Informix Error -3720: Permission not granted to allow add of table-name.

Cause and resolution

Permission not granted to allow add of table-name.

Your account has not been granted INSERT 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

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

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

Solutions / Resolution

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

Examples

Granting INSERT privilege

GRANT INSERT ON table-name TO myaccount;

Diagnostic Checks

Check whether the account has INSERT 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 INSERT specifically.
-3700 — "Permission not granted to allow reading of table-name." The equivalent privilege check for SELECT rather than INSERT.
-3710 — "Permission not granted to allow update of table-name." The equivalent privilege check for UPDATE rather than INSERT.

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