Answers.Body: <p>You will need to perform two operations for this</p>
  
  <ol>
  <li><p>Give Drupal mysql user to access CiviCRM database.</p></li>
  <li><p>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.</p></li>
  </ol>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-11T10:58:46.170Z
Answers.Text: Thanks Pradeep! How can I copy the content from 'Views Integration Settings' section to settings.php? Thanks!
Answers.UserDisplayName: santiagoelie
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-11T20:39:14.763Z
Answers.Text: Copy from UI and paste it at the end of the file.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-13T18:01:41.150Z
Answers.Text: 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!
Answers.UserDisplayName: santiagoelie
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-13T18:15:10.270Z
Answers.Text: You can raise a support ticket to aws for granting access or use cpanel/whm if you have access to it.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-11T09:08:44.000Z
Answers.LastActivityDate: 2018-10-11T09:08:44.000Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>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!</p>
  
Tags: <drupal><civicrm.settings.php>
Title: How to grant SELECT access for Drupal user to all CiviCRM Tables
ThreadText: # How to grant SELECT access for Drupal user to all CiviCRM Tables
  
  (Asked by: username_0 on 2018-10-10)
  
  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!
  
  **Tags:** drupal, civicrm.settings.php
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-10-11. Score: 1
  
  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
  
  > **Comments:**
  > **username_0**: Thanks Pradeep! How can I copy the content from 'Views Integration Settings' section to settings.php? Thanks!  
  > **username_1**: Copy from UI and paste it at the end of the file.  
  > **username_0**: 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!  
  > **username_1**: You can raise a support ticket to aws for granting access or use cpanel/whm if you have access to it.  
  
  ---
  
  