Optional security / definer is not allowed
Brought to you by:
ansgarbecker
Menu
▾
▴
1 Attachments
#3694 Optional security / definer is not allowed
New
Medium
Allows to generate SQL Code (functions, triggers) without a definer
HIGH
Defect
2017-09-29
2015-10-08
No
When defining functions and triggers, the DEFINER IS NOT OPTIONAL (as MySQL states in its documentation https://dev.mysql.com/doc/refman/5.0/en/create-trigger.html)
I want to leave blank de "definer" of a trigger definition for example, to avoid using security things of mysql, but HeidiSQL only allows you to choose "Definer" or "Invoker" from the list (I think that " " or "None" must be an option to make the security optional (and also the definer on trigger definition)
Because HeidiSQL requires the definer I constantly have trouble moving databases to other systems where different users are being used. Could this please be fixed?