Is SUPER privilege mandatory for scheduled event execution?
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)
Subject
Views
Written By
Posted
Is SUPER privilege mandatory for scheduled event execution?
99
August 30, 2018 07:27AM
Sorry, only registered users may post in this forum.
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.