Oninit
Talk to an expert →

Informix Error -6032: The user does not have SQL permission to INSERT rows into the table.

Cause and resolution

The user does not have SQL permission to INSERT rows into the table.

The user account that is running this program has not been granted INSERT 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

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

  1. No INSERT privilege granted on the table, per the archived catalogue — the direct, only cause.
Solutions / Resolution
  1. Have a DBA-privileged user GRANT the necessary INSERT 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 INSERT privilege on the table.
Related Errors / Related Topics
  • -6031 — "The user does not have SQL permission to SELECT the specified columns."
  • -6033 — "The user does not have SQL permission to UPDATE the specified columns."
  • -6034 — "The user does not have SQL permission to DELETE rows from the table."

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