Oninit
Talk to an expert →

Informix Error -8259: Cannot GRANT or REVOKE SETSESSIONAUTH privilege for role.

Cause and resolution

Cannot GRANT or REVOKE SETSESSIONAUTH privilege for role.

To grant or revoke SETSESSIONAUTH privilege for role is not allowed. Specify an individual user or PUBLIC.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8259 fires when GRANT/REVOKE SETSESSIONAUTH targets a role — per the official guidance, this isn't allowed.

  1. A role given as the target of GRANT/REVOKE SETSESSIONAUTH, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Specify an individual user or PUBLIC, per the official guidance, instead of a role.
Examples
Granting SETSESSIONAUTH to a role
GRANT SETSESSIONAUTH TO admin_role;
-- -8259: roles cannot receive SETSESSIONAUTH
Corrected
GRANT SETSESSIONAUTH TO jdoe;
Diagnostic Checks
  1. Check the target of the GRANT/REVOKE SETSESSIONAUTH statement, and use an individual user or PUBLIC instead of a role.
Related Errors / Related Topics
  • -8228 — "Cannot GRANT or REVOKE SETSESSIONAUTH privilege to or from PUBLIC." The complementary restriction — PUBLIC disallowed for the same privilege, rather than roles.

GRANT/REVOKE SETSESSIONAUTH targeted a role — use an individual user or PUBLIC instead.