[ckan-dev] datastore_search_sql, only works for creator of dataset?

Thu Dec 5 07:11:37 UTC 2013

To follow up:

I have the following settings in production.ini:
ckan.datastore.read_url = postgresql://datastore_default:MY-PASSWORD@localhost/datastore_default

Also, from the datastore_default database, I get the following result:
select * from information_schema.role_table_grants where grantee='datastore_default' and table_name in ('660e19fa-8838-4a5c-9495-0d7f94fab51e','f51463ac-d6ef-434e-bd40-b398c11fdc1d');
   grantor    |      grantee      |   table_catalog   | table_schema |              table_name              | privilege_type | is_grantable | with_hierarchy
--------------+-------------------+-------------------+--------------+--------------------------------------+----------------+--------------+----------------
ckan_default | datastore_default | datastore_default | public       | f51463ac-d6ef-434e-bd40-b398c11fdc1d | SELECT         | NO           | NO
ckan_default | datastore_default | datastore_default | public       | 660e19fa-8838-4a5c-9495-0d7f94fab51e | SELECT         | NO           | NO
(2 rows)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20131205/22702948/attachment-0003.html>