--echo # --echo # Bug #17598: privilege checks when trigger is executed. --echo # --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings create user u1; GRANT CREATE ON test.* TO u1; --echo # Change to user u1. --change_user u1,,test create table t1 (c1 int); --echo # Change to user root. --change_user root create user u2; GRANT INSERT, TRIGGER ON test.t1 TO u2; --echo # Change to user u2. --change_user u2,,test --echo # Create a trigger that updates the NEW pseudovariable. CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.c1 = 42; INSERT INTO t1 VALUES (1), (2), (3); SELECT * FROM t1; --echo # Change to user root. --change_user root DROP TRIGGER tr1; DROP TABLE t1; DROP USER u1, u2;