Unable to enable CiviCase
RESOLVED thanks to help from Hershel:
Unable to enable CiviCase - Definer v Invoker problem maybe

The solution was to enable remote connections for the specific MySQL database.