Informix Error -32135: Illegal session level for revoking table-level privileges.

Reasons / Common Causes

-32135 fires when a session attempts to revoke table-level privileges at a sensitivity level that doesn't match the table's own level — per the official guidance.

1. The session's sensitivity level doesn't equal the target table's sensitivity level, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Log in at (or switch to) the session level matching the table's sensitivity level, per the official guidance, before revoking the privilege.

Examples

N/A

No specific triggering statement is documented beyond a session-level/table-level mismatch.

Diagnostic Checks

1. Check the session's current sensitivity level against the target table's level, and match them before retrying.

Related Errors / Related Topics

• -32133 — "Illegal session level for granting table-level privileges." The mirror operation (grant) at the same table-level scope.
• -32134 — "Illegal session level for granting database-level privileges." The mirror operation (grant) at the database-level scope.
• -32136 — "Illegal session level for revoking database-level privileges." The same session-level rule, at the database level rather than table level.

The session's sensitivity level didn't match the target table's level — match them before revoking table-level privileges.