So this is becoming a bigger issue for me.
When I create or change a view on my hosted system, heidi makes the Security DEFINER. Then when my IP address changes (as it does every few months or when the power goes out at my office), I cannot remotely access my hosted databases until I add my new IP address to "Remote MySql" via cPanel. I usually remove my old address from "Remote MySql" as it is no longer needed. But now I realize that the MySql user user@<OldIpAddress> is also removed and then all my views fail until I change them all to be owned by user@<NewIpAddress>. And that is cumbersome as the view owner no longer exists so I have to delete the view and re-create it.
One solution on my part is to leave the OldIpAddress in "Remote MySql" so user@<OldIpAddress> is not deleted from MySql. But I would rather set the view to Security INVOKER and remove the bogus user.
Please, please, please - add an option for a view to have Security INVOKER.
(I am starting to use other MySql tools to change the view Security, but i really like the HeidiSql user interface over others).
Thanks.