Informix Error -32502: New session level not dominating the database level.

Reasons / Common Causes

-32502 fires when a SET SESSION LEVEL target doesn't dominate the target database's sensitivity level — per the official guidance.

1. The requested new session level doesn't dominate the database's level, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Use a different session level that dominates the database's level, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond a level-dominance failure against the database.

Diagnostic Checks

1. Compare the requested session level against the target database's level, and choose a dominating level.

Related Errors / Related Topics

• -32500 — "User does not have discrete privilege to change session levels." A related SET SESSION LEVEL restriction, on a missing privilege rather than level dominance.
• -32501 — "Login session level not dominating the new session level." A related session-level restriction, on dominance from the login session rather than over the database.

The requested session level didn't dominate the target database's level — choose a dominating level.