# Compare Schema Error

**URL:** <https://forums.toadworld.com/t/compare-schema-error/42660>\
**Category:** Toad Edge\
**Created:** [September 30, 2018, 11:31am UTC](https://forums.toadworld.com/t/compare-schema-error/42660 "2018-09-30T11:31:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pnreen](https://avatars.discourse-cdn.com/v4/letter/p/e36b37/32.png) [@pnreen](https://forums.toadworld.com/u/pnreen)\
**Post date:** [September 30, 2018, 11:31am UTC](https://forums.toadworld.com/t/compare-schema-error/42660/1 "2018-09-30T11:31:28Z")

</div>

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](https://global.discourse-cdn.com/quest/original/2X/c/c7fbf69d3863cead5a0c4220061be88f3be13e42.png)

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

 ![21](https://global.discourse-cdn.com/quest/original/2X/b/b7b9cfb771b4e910a93774ad2200210bee42335c.png)

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

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

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

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Petr.Chudanic](https://avatars.discourse-cdn.com/v4/letter/p/46a35a/32.png) [@Petr.Chudanic](https://forums.toadworld.com/u/Petr.Chudanic)\
**Post date:** [October 2, 2018, 10:17am UTC](https://forums.toadworld.com/t/compare-schema-error/42660/2 "2018-10-02T10:17:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![rachelgomez161999](https://avatars.discourse-cdn.com/v4/letter/r/e19adc/32.png) [@rachelgomez161999](https://forums.toadworld.com/u/rachelgomez161999)\
**Post date:** [March 3, 2023, 9:54am UTC](https://forums.toadworld.com/t/compare-schema-error/42660/3 "2023-03-03T09:54:29Z")

</div>

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