Informix Error -3730: Permission not granted to allow remove of table-name row.

Cause and resolution

Permission not granted to allow remove of table-name row.

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

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

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

Solutions / Resolution

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

Examples

Granting DELETE privilege

GRANT DELETE ON table-name TO myaccount;

Diagnostic Checks

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

Related Errors / Related Topics

-3700 — "Permission not granted to allow reading of table-name." The equivalent privilege check for SELECT rather than DELETE.
-3710 — "Permission not granted to allow update of table-name." The equivalent privilege check for UPDATE rather than DELETE.
-3720 — "Permission not granted to allow add of table-name." The equivalent privilege check for INSERT rather than DELETE.

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