Views : Syntax error or access violation: 1142 (???)

Question

I am trying to implement Views, but when I want to create an elementary users view, I get the following error :

SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'XYZ'@'localhost' for table 'civicrm_uf_match'

This, though I followed the Wiki : https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration

Here under is a partial copy of my settings.php file where I have copied the requested info :

---

$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'paroisse_drup275', 'username' => 'xyz', 'password' => 'abc', 'host' => 'localhost', 'port' => '', 'driver' => 'mysql', 'prefix' => 'dr_', ), ), );

$databases['default']['default']['prefix']= array( 'default' => 'dr_', 'civicrm_acl' => 'paroisse_civicrm.', 'civicrm_acl_cache' => 'paroisse_civicrm.', 'civicrm_acl_contact_cache' => 'paroisse_civicrm.', 'civicrm_acl_entity_role' => 'paroisse_civicrm.', 'civicrm_action_log' => 'paroisse_civicrm.', 'civicrm_action_mapping' => 'paroisse_civicrm.', 'civicrm_action_schedule' => 'paroisse_civicrm.', 'civicrm_activity' => 'paroisse_civicrm.', 'civicrm_activity_contact' => 'paroisse_civicrm.', ... );

---

I am in CiviCRM 4.7.6, with Drupal 7.43

Answer 1

Based on your comment, I see that each database only provides privileges to their respective user - and it seems implicit that you're using different users for each database.

That means that your Drupal MySQL user doesn't have access to the CiviCRM database. For Views to work properly, the Drupal user must have permission to run SELECT statements on the CiviCRM database. From the documentation you linked: "If you have different database users for your CiviCRM and Drupal databases, then you need to grant SELECT access for the Drupal user to all the CiviCRM tables."

Please try granting this access and try again, you should be good to go!