I am trying to compare schema but receive an error that the PROCESS permission is needed.
I have developed my own schema analysis tools before and I am 100% sure that this permission isn’t needed as my tools are able to analyse the schema using the same account without any problems.
There’s something it’s doing that needs that permission that it should be possible to enable or disable. Unfortunately when the error occurs it gives no indication of on which sub-step or even the query (presumably it’s trying to view the process list though).
This is disappointing because the main reason to use this tool and pay for it is the schema compare (which doesn’t support multiple databases at once as well and the data compare appears to have gone).