Oninit
Talk to an expert →

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

Cause and resolution

Not an owner of xadatasource type or DBA.

The user executing a DROP XADATASOURCE TYPE 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

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

  1. The user isn't the owner of the xadatasource type, 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 type's owner run the DROP XADATASOURCE TYPE 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 type's owner and the executing user's privileges, and rerun as the owner or a DBA.
Related Errors / Related Topics
  • -9259 — "Not an owner of xadatasource or DBA." The same class of authorization error, for xadatasource instances rather than types.

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