[GeoNode-devel] How to apply Geonode permissions for Postgres database access? For Tableau etc

[Patrick Dufour]

I've looked into this in the past, but found no great solution.  I'd look
into Row Level Security(RLS) and foreign data wrappers to access a
protected CSV API from Django.  Might work.

https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.html

Regards,
Patrick

On Nov 1, 2017 10:53 PM, "Rob Atkinson" <rob at metalinkage.com.au> wrote:

> Maybe tableau can access via HTTP GET? geoserver also has a lighter-weight
> filter (CQL_FILTER) that makes URLs easier to craft..
>
> I am thinking of a django module as a lightweight API wrapper for Geonode,
> using OpenAPI (was swagger) to document these APIS - but also for a funky
> WMS-by-feature id  capability.
>
> Rob Atkinson
>
> On Thu, 2 Nov 2017 at 13:29 Jonathan Doig <j.doig at unsw.edu.au> wrote:
>
>> Hi all
>>
>>
>>
>> Visualisation software like Tableau can get data from remote databases
>> including Postgres. I’ve verified that works in our Geonode, with just a
>> couple of config changes in Postgres.
>>
>>
>>
>> But how do I allow Tableau users to access layers from Postgres while
>> honouring Geonode’s Django-level ‘Download’ permission?
>>
>>
>>
>> Do I have to duplicate Geonode’s users and access controls as Postgres
>> users and privileges?
>>
>>
>>
>> This could be done generically …is there a tool for that?
>>
>>
>>
>> Or is there a better way to expose Geonode data to Tableau? (I’ve just
>> given their sales people a serve for supporting 32 flavours of commercial
>> database but not one International Standard like WFS…).
>>
>>
>>
>> Regards
>>
>> Jonathan
>>
>>
>>
>> [image: Title: City Futures - Description: City Futures Logo]
>>
>> *Jonathan Doig*
>>
>> Software Engineer, City Futures Research Centre
>> Built Environment
>>
>> UNSW SYDNEY NSW 2052 AUSTRALIA
>> M: +61 409 049185 <0409%20049%20185>
>>
>> T: +61 (2) 9385 5319
>>
>> E: *j.doig at unsw.edu.au <j.doig at unsw.edu.au>*
>>
>> W: cityfutures.net.au <http://www.cityfutures.net.au/>
>>
>>
>> CRICOS Provider Code 00098G
>>
>> *Think green:** Please consider the environment before printing this
>> email*
>>
>>
>> _______________________________________________
>> geonode-devel mailing list
>> geonode-devel at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/geonode-devel
>>
>
> _______________________________________________
> geonode-devel mailing list
> geonode-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-devel
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20171101/d29a9d5f/attachment.html>