[code]Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2089711
Server version: 5.1.39-log MySQL Server
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> CREATE TRIGGER activity_summary_bu
-> BEFORE UPDATE ON activity_summary FOR EACH ROW
-> SET NEW.activity_summary = 5;
ERROR 1142 (42000): TRIGGER command denied to user ‘essnadmin’@‘waratahs.dreamhost.com’ for table ‘activity_summary’
Any update on this? I need to create an audit trail for some of my tables, and would really prefer to do it via triggers, rather than manual inserts prior to updates.