CiviCRM Community Forums (archive)

I've just upgraded to 2.1.2, partly to take advantage of the Views integration which should enable me to have a Dryupal page showing upcoming CiviEvents.

However, after getting this all set up I'm getting a warning that my Drupal database user does not have Select privileges for my CiviCRM database. Of course when I did the initial install I followed best practice and set up two separate databases. My hosting provider, presumably for reasons of security, forces me to create different database users for each database. I'm guess ing that this is not uncommon (I know of at least one other hosting provider with a similar policy).

Firstly, am I correct in interpreting the warning message?:

user warning: SELECT command denied to user 'user'@'localhost' for table 'civicrm_event' query: SELECT civicrm_event.id AS id, civicrm_event.title AS civicrm_event_title, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.end_date AS civicrm_event_end_date, civicrm_event.description AS civicrm_event_description FROM ukbhc_civicrm.civicrm_event civicrm_event LIMIT 0, 10 in /var/www/vhosts/example.com/httpdocs/sites/all/modules/views/includes/view.inc on line 723.

Or is there something else that I'm missing?

If, as seems reasonable, the Drupal db user needs at least select privileges for the CiviCRM database, can I suggest that this information is prominently displayed in the appropriate section/s of the documentation? I'm currently hoping that my hosting provider can help me get round this issue, as I really don't want to consider moving hosts or otherwise reconfiguring at this late stage. I would not want others to fall into this trap.

Regards
Graham

Thanks for this. I missed the "community editable" feature. I've also added a bit on this issue to http://wiki.civicrm.org/confluence/display/CRMDOC/Install+2.1+for+Drupal

This one has caught me out, as my current hosting provider has a "helpful" feature whereby - using the dreaded Plesk control panel - I can create databases, but cannot create users that are common to both databases. I may yet have to move all my CiviCRM tables into my Drupal DB in order to get this sorted out. Had I been aware of this issue when selecting a host I could have saved myself this headache.

Regards
Graham