Devart Forums

Posted: **Fri 03 Dec 2021 11:24**

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

Posted: **Sat 04 Dec 2021 10:35**

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

Posted: **Fri 10 Dec 2021 07:49**

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

Posted: **Fri 10 Dec 2021 08:24**

Thank you, much appreciated.

Devart Forums

DB Project Syntax Checking Error

DB Project Syntax Checking Error

Re: DB Project Syntax Checking Error

Re: DB Project Syntax Checking Error

Re: DB Project Syntax Checking Error