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.