220
220
GRANT UPDATE ON `priv_db`.* TO 'test_yesprivs'@'localhost'
222
222
Grants for test_noprivs@localhost
224
224
GRANT SELECT, INSERT, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `priv_db`.* TO 'test_noprivs'@'localhost'
226
226
create trigger trg4b_1 before UPDATE on t1 for each row