[ckan-dev] datastore_search_sql, only works for creator of dataset?
Henrik Aagaard Sørensen
BU1G at tmf.kk.dk
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>
More information about the ckan-dev
mailing list