3

I have 2 databases for Drupal and CiviCRM. How can I grant SELECT access for Drupal user to all CiviCRM tables? I am using AWS RDS Databases. Thanks so much!

Improve this question
2

You will need to perform two operations for this

  1. Give Drupal mysql user to access CiviCRM database.

  2. Add CiviCRM tables in Drupal's settings.php i.e Navigate to CiviCRM >> Administer >> System Settings >> CMS Database Integration. Copy the content from 'Views integration settings' section to settings.php. Clear Drupal cache.

Pradeep

Improve this answer
4
  • Thanks Pradeep! How can I copy the content from 'Views Integration Settings' section to settings.php? Thanks!
    – santiagoelie
    Oct 11 '18 at 10:58
  • Copy from UI and paste it at the end of the file.
    – Pradeep Nayak
    Oct 11 '18 at 20:39
  • I don't know how to give access drupal mysql user to access CiviCRM database. Because I am using aws rds? Do you know how to? Please help. Thanks so much!
    – santiagoelie
    Oct 13 '18 at 18:01
  • You can raise a support ticket to aws for granting access or use cpanel/whm if you have access to it.
    – Pradeep Nayak
    Oct 13 '18 at 18:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.