title: In MySQL what privileges are required for executing a trigger?
body: <p>I find the explanation of DEFINER in the MySQL manual confusing, so I am not sure what privileges are required for the 'execute user' under which the application is running. For security, I like to limit the 'execute user' to the least amount of permissions needed.</p>
  
  <p>I understand that the creator of a trigger/stored procedure requires SUPER privileges, but does the 'execute user' also require SUPER permissions?</p>
  
  <p>I created a trigger under a user that eventually lost privileges to my database. The 'execute user' did Not have SUPER privileges and a MySQL UPDATE that had a trigger failed.</p>
  
  <p>I gave SUPER privileges to the 'execute user'  and I changed the DEFINER to root by dropping and creating the triggers and it all works. Did I have to give SUPER privileges to the 'execute user' or do I have to be sure the DEFINER user is still around and has SUPER privileges?</p>
  
  <p>What are the best practices for user management with TRIGGERS and STORED PROCEDURES for MySQL? </p>