CiviCRM Community Forums (archive)

Here http://wiki.civicrm.org/confluence/display/CRMDOC/Views2+Integration+Module
I read that for integrating Views2 and CiviCRM, I need to ensure that your Drupal DB user has SELECT rights to your CiviCRM DB.

I checked in drupalvaluehosting.com the privileges of users db f mysql and here is the list:
ALL PRIVILEGES:
SELECT    CREATE
INSERT    ALTER
UPDATE    DROP
DELETE    LOCK TABLESLOCK TABLES
INDEXINDEX    REFERENCESREFERENCES
CREATE TEMPORARY TABLES    CREATE ROUTINECREATE ROUTINE

It mean that I have the SELECT rights and I can install civicrm in a different db from drupal without problems of views sync?

I checked also bluehost.com :
ALL PRIVILEGES
SELECT    CREATE
INSERT    ALTER
UPDATE    DROP
DELETE    LOCK TABLES
INDEX    REFERENCES
CREATE TEMPORARY TABLES    CREATE ROUTINE
It mean that also on bluehost I can install civicrm and drupal into 2 different db?