CiviCRM Community Forums (archive)

We've just come up against a problem installing CiviCase on a pre exisiting CiviCRM installation and I thought I'd post this up for anyone else that runs into the same issue.
Every time we tried to enable CiviCase we would get the error 'Could not create Case views'.

After much head scratching and looking back though the code we traced this back to insufficient permissions for the database user account we had set up.

We usually use the recommended database permissions for Drupal 7 for the CiviCRM database eg.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `database`.* TO 'database_user'@'localhost' IDENTIFIED BY 'password';

However it seems that (at least during set up) CiviCase requires the additional permission 'CREATE VIEW' so if you're running your civi database with a user without ALL PRIVILEGES make sure you grant this additional permission to your database user to ensure you can run CiviCase ok.

Russ

No problem - issue now filed.