handle the correct grants for service and monitor upgrade related

The request is about to avoid all the manual work and check grants related on database.
You have to think in a way that major upgrade can be done in HA, where you have two or more maxscales running with different major version and also cases when you skip major release, for instance form maxscle 23 to 25 and for the future.

Maxscale, instead relay to the documentation all times , should check the user that are used on monitor/replication/service and check if some grants are there or missing or need to add or eventually can be removed.

you can do also do this this in eventually a separate script that can read the encryption and ssl configuration, connect to DBS and report the outcome grants

may initially integrate directly on the upgrade can be a bit invasive, or you can find the way to even have a separate script that can ran package independent.

Example, i am running maxscale 23, i run the grant_check_25 and it report the grants that i need to add or eventually removed.

Or even done on packages itself once maxscale25 is installed for the first time but not run yet. maxchecl_grants_25

This will bring the benefit to have the right grants in place and not discovered only where is switchover or failover fail