Is SUPER privilege mandatory for scheduled event execution?

[harry sheng]

Here is the message in mysql server log:

Event Scheduler: [ionapps@%][ionapps_collector.partition_management] Access denied; you need (at least one of) the SUPER privilege(s) for this operation

ionapps@% creates a stored-procedure (for modifying or managing table partitions in schema ionapps_collector) and the partition_management event in schema ionapps_collector. The event is scheduled to run once every day.

The stored-procedure and event are defined and created by ionapps@% in schema ionapps_collector. No issue on calling the stored-procedure to manage the table partitions, the failure is from the scheduler as seen in the above message.

Is SUPER privilege required for triggering the event or for altering the table partition?

The environment:

Linux localhost.localdomain 2.6.32-504.el6.x86_64 #1 SMP Tue Sep 16 01:56:35 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux

Server version: 5.7.10-log MySQL Community Server (GPL)