Informix Error -32519: Passwords are only allowed in SET SESSION AUTHORIZATION statements for a trusted connection using a trusted context.
Cause and resolution
Passwords are only allowed in SET SESSION AUTHORIZATION statements for a trusted connection using a trusted context.
A SET SESSION AUTHORIZATION statement with a password, was executed outside of a trusted connection.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-32519 fires when a SET SESSION AUTHORIZATION statement supplies a password outside a
trusted-context connection — per the official guidance.
- A
SET SESSION AUTHORIZATION ... PASSWORDstatement executed outside a trusted connection, per the official guidance — the direct, only cause.
Solutions / Resolution
- Only supply a password to
SET SESSION AUTHORIZATIONover a trusted connection using a trusted context, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a password supplied outside a trusted connection.
Diagnostic Checks
- Confirm whether the connection is a trusted connection under a trusted context, and remove the password argument if not.
Related Errors / Related Topics
- -32507 — "Cannot set session authorization." A related
SET SESSION AUTHORIZATIONrestriction, on missing DBA privilege rather than password usage outside a trusted context.
A password was supplied to SET SESSION AUTHORIZATION outside a trusted connection — only
trusted-context connections may supply one.