note to self, how to change the definer of a mysql stored procedure
This is a useful one if, like us, you find that the account used to create the procedure doesn't have the privileges required to execute it, or perhaps you've revoked the original definers grant. (DoH!)
ALTER PROCEDURE procedure_name SQL SECURITY DEFINER;javascript:void(0)
Syndicated 2010-09-01 16:25:00 (Updated 2010-09-01 17:46:04) from Danny Angus