I have set up an external database source using the Forena reports module and the PDO driver. This data source has its data security method set to "Use Drupal permissions". The only other option is "Match values provided by a data block".
There is a matching Drupal permission for the data source in admin/people/permissions labelled "Access MyDB data". (Machine name "access my_db data"). The "Access MyDB data" permission has only been granted to a couple of roles.
What I have tried: I put a line in my .sql file for the data blocks built on this source:
--ACCESS=access my_db data
This prevents anyone from getting any results from the report based on this data block, even the Drupal administrator.
I removed the above line in the .sql file. This allows any logged in user to access the report. It does not respect the permission "Access MyDB data".
How do I set this up so that the access to this data block (and therefore the reports using it) is limited to only those who have the "access my_db data" permission?