221
221
GRANT UPDATE ON `priv_db`.* TO 'test_yesprivs'@'localhost'
223
223
Grants for test_noprivs@localhost
225
225
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'
227
227
create trigger trg4b_1 before UPDATE on t1 for each row