Compare Schema Error

Toad Edge
1

Hi,

Since I use Toad Edge version (2.0.2) I'm getting an error while comparing the tables of 2 schemas.

The error I'm getting is;
Error occurred:SELECT command denied to user @ip4dab94bd.direct-adsl.nl for table 'user'

02
ToadEdge_v2.02.png1210×276 17.3 KB

I don't get this error when I do/run the same In a previous version (1.2.1).

21
ToadEdge_v1.21.png1154×310 15.4 KB

Besides that my database doesn't has a table named 'user'

I also tried other schemas. But everywhere I get the same error. :disappointed:

Someone any idea why this error pops up. And/Or what can I do about it

Thanks in advance

2

Hello,
this error is caused by query to user mysql.table which you don’t have rights to access. For compare to work in current version of toad edge you need to get this access.
This query to user table is a check for another privileges and based on that proper query for compare is generated. We will consider modifying it so that it won’t fail - in 2.0.5 version of Edge, we’ll keep you informed.

Petr Chudanic
Edge dev

3

To resolve the issue you would need to review the raw data file and look at the fields in this entity and make any necessary changes before resubmitting. The schema tree diagram may assist you in identifying the correct order and consequently rectifying the issue with the file.

Regards,
Rachel Gomez