Informix Error -32118: No Index privilege for creating an index.

Reasons / Common Causes

-32118 fires when a session without Index privilege attempts to create an index on a table — per the official guidance.

1. The session lacks Index privilege on the table, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Request Index privilege on the table from its owner or the database administrator, per the official guidance's implication.

Examples

N/A

No specific triggering statement is documented beyond a missing Index privilege.

Diagnostic Checks

1. Confirm whether the session holds Index privilege on the target table, and request it if missing.

Related Errors / Related Topics

• -32117 — "Illegal session level for creating an index." A related index-creation error, on a session-level/table-level mismatch rather than missing Index privilege.

A session without Index privilege tried to create an index — request Index privilege on the table.