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;

connect(user4,localhost,user4,,);

--vertical_results
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
SHOW CREATE TRIGGER db_datadict2.trg1;

SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE
event_object_schema = 'db_datadict2';
--horizontal_results
connection default;
disconnect user4;
USE db_datadict2;
DROP TRIGGER trg1;
DROP TABLE t1;
USE test;
DROP DATABASE db_datadict2;
DROP USER 'user4'@'localhost';