How to grant SELECT access for Drupal user to all CiviCRM Tables
You will need to perform two operations for this


Give Drupal mysql user to access CiviCRM database.
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