It is important to understand that an event is executed with the privileges of its definer, and that it cannot
perform any actions for which its definer does not have the requisite privileges. For example, suppose that
has the EVENT
privilege for myschema
. Suppose also that this user has the
SELECT
privilege for myschema
, but no other privileges for this schema. It is possible
to create a new event such as this one:
example :
CREATE EVENT new_event_by_bikash
ON SCHEDULE
EVERY 11 SECOND
DO
INSERT INTO books(title) VALUES ('author bikash');