Oninit
Talk to an expert →

Informix Error -9405: Must be owner of user-defined aggregate <aggregate-name> or DBA. </aggregate-name>

Cause and resolution

Must be owner of user-defined aggregate <aggregate-name> or DBA. </aggregate-name>

You attempted to drop a user-defined aggregate that someone else created. To drop a user-defined aggregate, you must own (be the creator of) the aggregate or you must have DBA privilege.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9405 fires when a user tries to drop a user-defined aggregate they didn't create — per the official guidance.

  1. The executing user neither owns (created) the aggregate nor has DBA privilege, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Have the aggregate's owner drop it, per the official guidance's implication.
  2. Otherwise, have a user with DBA privilege drop it, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an unauthorized DROP AGGREGATE attempt.

Diagnostic Checks
  1. Check the aggregate's owner in the system catalog and the executing user's privileges, and rerun as the owner or a DBA.
Related Errors / Related Topics
  • -9401 — "Cannot re-define or drop builtin aggregate ." A related DROP-AGGREGATE restriction, on built-in aggregates rather than ownership.

The user wasn't the aggregate's owner or a DBA — rerun DROP AGGREGATE as the owner or a DBA.