CREATE DATABASE db_datadict2;
CREATE USER 'user4'@'localhost';
GRANT TRIGGER ON db_datadict1.* TO 'user4'@'localhost';
CREATE TABLE db_datadict2.t1 (f1 INT, f2 INT);
USE db_datadict2;
CREATE TRIGGER trg1 AFTER UPDATE ON db_datadict2.t1
FOR EACH ROW UPDATE db_datadict1.t1 SET f1 = new.f1, f2 = new.f2;
SHOW CREATE TRIGGER db_datadict2.trg1;
ERROR 42000: Access denied; you need the TRIGGER privilege for this operation
SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE
event_object_schema = 'db_datadict2';
USE db_datadict2;
DROP TRIGGER trg1;
DROP TABLE t1;
USE test;
DROP DATABASE db_datadict2;
DROP USER 'user4'@'localhost';