Separate DEFINER and SQL SECURITY in exclude backup options
It only makes sense to combine these two options when SQL SECURITY is set to DEFINER. In the other case (INVOKER) it will cause a problem if the DEFINER is specified when restoring the database to a different environment - user will not exist or will not have the right privileges. "Exclude DEFINER" and "Exclude SQL SECURITY" should be two separate options when backing up a database.
Alan Gray
shared this idea
-
Support Team
commented
Dear User,
Thank you for your patience.
We would like to kindly inform you that we have released a new version of the tool. This version includes a lot of fixes and some new features.
The full list of changes you can find via the link below:
https://www.devart.com/dbforge/mysql/studio/revision_history.html
You can upgrade to the new version within the app, just look on the bar on top for "Help->Check for updates".
Also, you can use the following link:
https://www.devart.com/dbforge/mysql/studio/download.html
In case you have any additional questions or need any kind of assistance, kindly let me know.Thanks in advance,
Devart Team
www.devart.com -
Support Team
commented
Hi,
Thank you for reaching out to us! Hope you are doing well!
Kindly be informed that an appropriate ticket was created for our Product team to consider the feasibility of implementing this functionality.
Best,
Devart Support Team