Oninit
Talk to an expert →

Informix Error -8229: User <user-name> does not have SETSESSIONAUTH privilege. </user-name>

Cause and resolution

User <user-name> does not have SETSESSIONAUTH privilege. </user-name>

Only users holding SETSESSIONAUTH privilege can perform SET SESSION AUTHORIZATION operation. Ask the DBSECADM to grant the privilege.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8229 fires when a user without SETSESSIONAUTH privilege attempts SET SESSION AUTHORIZATION — per the official guidance, only users holding this privilege can perform that operation.

  1. The user lacks SETSESSIONAUTH privilege, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Ask the DBSECADM to grant the privilege, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond SET SESSION AUTHORIZATION attempted without the privilege.

Diagnostic Checks
  1. Confirm the user's SETSESSIONAUTH privilege, and have a DBSECADM grant it if missing.
Related Errors / Related Topics
  • -8228 — "Cannot GRANT or REVOKE SETSESSIONAUTH privilege to or from PUBLIC." A related SETSESSIONAUTH restriction, about the grant target rather than a missing privilege.

The user lacks SETSESSIONAUTH privilege for SET SESSION AUTHORIZATION — have a DBSECADM grant it.