Oninit
Talk to an expert →

Informix Error -9259: Not an owner of xadatasource or DBA.

Cause and resolution

Not an owner of xadatasource or DBA.

The user executing a DROP XADATASOURCE statement is not authorized because the user is not the owner of the xadatasource type or does not have DBA privileges.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9259 fires when the user executing a DROP XADATASOURCE statement isn't authorized to do so — per the official guidance.

  1. The user isn't the owner of the xadatasource (its type, per the official text), per the official guidance — the first named cause.
  2. The user doesn't have DBA privileges, per the official guidance — the second named cause.
Solutions / Resolution
  1. Have the xadatasource's owner run the DROP XADATASOURCE statement, per the official guidance's implication.
  2. Otherwise, have a user with DBA privileges run it, per the official guidance's implication.
Examples
N/A

No specific triggering statement is documented beyond an unauthorized user attempting the DROP.

Diagnostic Checks
  1. Check the xadatasource's owner and the executing user's privileges, and rerun as the owner or a DBA.
Related Errors / Related Topics
  • -9258 — "Not an owner of xadatasource type or DBA." The same class of authorization error, for xadatasource types rather than instances.

The user wasn't the xadatasource's owner or a DBA — rerun as the owner or a DBA.