Informix Error -32510: User does not have discrete privilege to change session authorization.

Cause and resolution

User does not have discrete privilege to change session authorization.

You must obtain the PRIV_CANSETIDENTITY discrete privilege from the DBSSO before the start of a session in which you use the SET SESSION AUTHORIZATION statement.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32510 fires when a session without the PRIV_CANSETIDENTITY discrete privilege attempts SET SESSION AUTHORIZATION — per the official guidance.

The session lacks PRIV_CANSETIDENTITY, per the official guidance — the direct, only cause; this discrete privilege must be obtained from the DBSSO before the session starts.

Solutions / Resolution

Obtain PRIV_CANSETIDENTITY from the DBSSO before the session begins, per the official guidance — discrete privileges can't be granted mid-session.

Examples

N/A

No specific triggering statement is documented beyond a missing PRIV_CANSETIDENTITY privilege.

Diagnostic Checks

Confirm whether the session was started with PRIV_CANSETIDENTITY, and request it from the DBSSO for future sessions if missing.

Related Errors / Related Topics

-32507 — "Cannot set session authorization." A related SET SESSION AUTHORIZATION restriction, on missing DBA privilege rather than the discrete PRIV_CANSETIDENTITY privilege.
-32509 — "Bad session authorization format." A related SET SESSION AUTHORIZATION error, on an invalid user-name argument.

The session lacked the PRIV_CANSETIDENTITY discrete privilege for SET SESSION AUTHORIZATION — obtain it from the DBSSO before the session starts.