MySQL Forums
Forum List  »  Events (Job Scheduler)

Is SUPER privilege mandatory for scheduled event execution?
Posted by: harry sheng
Date: August 30, 2018 07:27AM

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)

Options: ReplyQuote

Written By
Is SUPER privilege mandatory for scheduled event execution?
August 30, 2018 07:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.