CiviCRM Community Forums (archive)

I have a multisite installation with two websites sharing the same civicrm database. However when drupal wants to query it (with views) it will use the username of the drupal database wich does not exist on the civicrm database (and cannot be added).

Is there a way to put in the drupal settings.php a username/password for the prefix tables?

I have a multisite installation with two websites sharing the same civicrm database. However when drupal wants to query it (with views) it will use the username of the drupal database wich does not exist on the civicrm database (and cannot be added).

I don’t think there’s a good solution in your case; the whole idea of user permissions is that Drupal works with the permissions of its (db) user, and if you want Drupal to query CiviCRM via views, then you need to allow Drupal’s db user to select from CiviCRM’s tables. This is how it’s supposed to work, so I doubt there’s a sane workaround.