Informix Error -32136: Illegal session level for revoking database-level privileges.

Reasons / Common Causes

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

1. The session's sensitivity level doesn't equal the target database'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 database's sensitivity level, per the official guidance, before revoking the privilege.

Examples

N/A

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

Diagnostic Checks

1. Check the session's current sensitivity level against the target database'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 table-level scope.
• -32134 — "Illegal session level for granting database-level privileges." The mirror operation (grant) at the same database-level scope.
• -32135 — "Illegal session level for revoking table-level privileges." The same session-level rule, at the table level rather than database level.

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