Oninit
Talk to an expert →

Informix Error -6034: The user does not have SQL permission to DELETE rows from the table.

Cause and resolution

The user does not have SQL permission to DELETE rows from the table.

The user account that is running this program has not been granted DELETE privilege on the current table. A user with DBA privileges for the database should use the SQL statement GRANT to grant the necessary privilege. Then run the program again.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-6034 fires when the running account lacks DELETE privilege on the current table — per the archived catalogue.

  1. No DELETE privilege granted on the table, per the archived catalogue — the direct, only cause.
Solutions / Resolution
  1. Have a DBA-privileged user GRANT the necessary DELETE privilege, per the archived catalogue, then run the program again.
Examples
N/A

No specific triggering statement is documented beyond the function-level condition described above.

Diagnostic Checks
  1. Check the account's current DELETE privilege on the table.
Related Errors / Related Topics
  • -6031 — "The user does not have SQL permission to SELECT the specified columns."
  • -6032 — "The user does not have SQL permission to INSERT rows into the table."
  • -6033 — "The user does not have SQL permission to UPDATE the specified columns."

Missing DELETE privilege — have a DBA grant it, then retry.