Schema Comparison 7.4.201 – accessing the ‘user’ table

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Sławek
Posts: 9
Joined: Tue 06 Mar 2018 14:34

Schema Comparison 7.4.201 – accessing the ‘user’ table

Post by Sławek » Thu 26 Apr 2018 08:54

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
Devart Team
Posts: 2830
Joined: Fri 24 Jun 2011 14:17

Re: Schema Comparison 7.4.201 – accessing the ‘user’ table

Post by alexa » Thu 26 Apr 2018 09:53

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
Posts: 9
Joined: Tue 06 Mar 2018 14:34

Re: Schema Comparison 7.4.201 – accessing the ‘user’ table

Post by Sławek » Thu 26 Apr 2018 12:34

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
Devart Team
Posts: 2830
Joined: Fri 24 Jun 2011 14:17

Re: Schema Comparison 7.4.201 – accessing the ‘user’ table

Post by alexa » Fri 11 May 2018 08:30

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?

Post Reply