Schema Comparison 7.4.201 – accessing the ‘user’ table

[Sławek]

The following error message shows at “object describing” stage:
Cannot describe an object. SELECT command denied to user ... for table ‘user’

It can be ignored, however, it’s not known whether ignoring has influence on the comparison results.
At least, it’s very annoying.

It does not occur in 7.2.78 (used for the same physical databases !).

[alexa]

Could you please perform the following:
1. Select 'Database -> Security Manager' from the main menu.
2. Select the connection.
3. Select the user.
4. Right-click the user and select 'Generate Script As -> CREATE -> ...' from the popup menu.
5. Provide us the generated script.
6. Provide us the CREATE definition of the table you are experiencing the issue with.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

[Sławek]

It's impossible to generate such a script because the user I use to log in to one of the databases does not have rights to select data from mysql.user.

I want to highlight again the fact that there is no such issue in 7.2.78 (and wasn't in at least a few earlier versions) with the same databases and credentials.

[alexa]

The behavior in the new version as well as in the old one is the same.

Could you please provide us the exact script to create the role?