19.7. Privileges Required for Triggers

To create or destroy triggers with CREATE TRIGGER or DROP TRIGGER, you must have the SUPER privilege. This is likely to change MySQL 5.1, such that the required privilege will be CREATE TRIGGER.

If the triggered statement uses OLD or NEW, there are additional privilege requirements:

• To assign the value of a column with SET NEW.col_name = value, you must have the UPDATE privilege for the column.

• To use NEW.col_name in an expression to refer to the new value of a column, you must have the SELECT privilege for the column.