DB Project Syntax Checking Error

[TheRamraider]

Hi ,

I am having an issue with errors building a db project when running a script that runs perfectly on its own.

The issue seem to be around dynamic privileges.

eg.

Code: Select all

CREATE ROLE 'all_read';
GRANT EXECUTE, SELECT, SHOW DATABASES, SHOW VIEW, SHOW_ROUTINE ON *.* TO 'all_read'@'%';

This runs fine as a stand alone script, but in the project refuses to build saying that 'SHOW_ROUTINE' is an unexpected symbol. This also happens for 'FLUSH_OPTIMIZER_COSTS' and a few others, all of which are dynamic privileges.

Anyone think why this might be happening, I have the latest version (Pro).

Thanks

[alexa]

We will fix this issue in one of the next product builds.

[dzhanhira]

Kindly be informed that a fixed version is available for downloading https://www.devart.com/dbforge/mysql/st ... nload.html

[TheRamraider]

Thank you, much appreciated.