Oninit
Talk to an expert →

Informix Error -32509: Bad session authorization format.

Cause and resolution

Bad session authorization format.

The user name that is supplied as an argument to the SET SESSION AUTHORIZATION statement is invalid. Supply the user ID of a valid user.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32509 fires when the user name supplied to SET SESSION AUTHORIZATION is invalid — per the official guidance.

  1. An invalid user name supplied to SET SESSION AUTHORIZATION, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Supply the user ID of a valid user, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an invalid user-name argument.

Diagnostic Checks
  1. Check the user name passed to SET SESSION AUTHORIZATION against the system's actual valid user IDs.
Related Errors / Related Topics
  • -32507 — "Cannot set session authorization." A related SET SESSION AUTHORIZATION error, on missing DBA privilege rather than an invalid user-name argument.

SET SESSION AUTHORIZATION's user name argument wasn't a valid user ID — supply a valid one.