CiviCase requires database 'CREATE VIEW' permission to be enabled

CiviCase cannot be enabled using standard Drupal recommended database permissions eg.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `database`.* TO 'database_user'@'localhost' IDENTIFIED BY 'password';

Additional permission of 'CREATE VIEW' is required otherwise enabling of CiviCase component fails with the error 'Could not create Case views'

Perhaps an error detailing what db permissions are missing would be helpful.