<div dir="auto">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.<div dir="auto"><br><div dir="auto"><a href="https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.html">https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.html</a><br></div><div dir="auto"><br></div><div dir="auto"><div dir="auto">Regards,</div><div dir="auto">Patrick</div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Nov 1, 2017 10:53 PM, "Rob Atkinson" <<a href="mailto:rob@metalinkage.com.au">rob@metalinkage.com.au</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Maybe tableau can access via HTTP GET? geoserver also has a lighter-weight filter (CQL_FILTER) that makes URLs easier to craft..<div><br></div><div><div>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.</div></div><div><br></div><div>Rob Atkinson</div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, 2 Nov 2017 at 13:29 Jonathan Doig <<a href="mailto:j.doig@unsw.edu.au" target="_blank">j.doig@unsw.edu.au</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-AU" link="blue" vlink="purple">
<div class="m_6120343540692983533m_2804492661259819845WordSection1">
<p class="MsoNormal">Hi all<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">But how do I allow Tableau users to access layers from Postgres while honouring Geonode’s Django-level ‘Download’ permission?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Do I have to duplicate Geonode’s users and access controls as Postgres users and privileges?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">This could be done generically …is there a tool for that?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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…).<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards<u></u><u></u></p>
<p class="MsoNormal">Jonathan<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<table class="m_6120343540692983533m_2804492661259819845MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="background:white;border-collapse:collapse">
<tbody>
<tr style="page-break-inside:avoid">
<td width="164" style="width:123.35pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal" style="margin-right:4.75pt;margin-bottom:0cm;margin-left:1.7pt;margin-bottom:.0001pt">
<span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1f497d"><img width="143" height="107" style="width:1.4895in;height:1.1145in" id="m_6120343540692983533m_2804492661259819845Picture_x0020_1" alt="Title: City Futures - Description: City Futures Logo"></span><span style="color:#1f497d"><u></u><u></u></span></p>
</td>
<td width="408" valign="top" style="width:306.2pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Jonathan Doig</span></b><b><span lang="EN-US" style="color:#1f497d"><u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Software Engineer</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">,
City Futures Research Centre</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Built Environment</span><span lang="EN-US" style="color:#1f497d"><u></u><u></u></span></p>
<p class="m_6120343540692983533m_2804492661259819845MsoNormalCxSpMiddle" style="margin-left:1.7pt;text-autospace:none">
<span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">UNSW SYDNEY NSW 2052 AUSTRALIA</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">M: <a href="tel:0409%20049%20185" value="+61409049185" target="_blank">+61 409 049185</a></span><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black"><u></u><u></u></span></p>
<p class="m_6120343540692983533m_2804492661259819845MsoNormalCxSpMiddle" style="margin-left:1.7pt;text-autospace:none">
<span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">T: +61 (2) 9385
</span><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">5319<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">E:
</span><u><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0563c1"><a href="mailto:j.doig@unsw.edu.au" target="_blank"><span style="color:#0563c1">j.doig@unsw.edu.au</span></a><u></u><u></u></span></u></p>
<p class="m_6120343540692983533m_2804492661259819845MsoNormalCxSpMiddle" style="margin-left:1.7pt;text-autospace:none">
<span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">W:
</span><span style="color:#1f497d"><a href="http://www.cityfutures.net.au/" target="_blank"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0563c1">cityfutures.net.au</span></a></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black"><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#9e9e9e">CRICOS Provider Code 00098G</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#9e9e9e"><u></u><u></u></span></p>
<p class="MsoNormal"><b><i><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#92d050">Think green:</span></i></b><i><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#92d050">
Please consider the environment before printing this email</span></i><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#9e9e9e"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
______________________________<wbr>_________________<br>
geonode-devel mailing list<br>
<a href="mailto:geonode-devel@lists.osgeo.org" target="_blank">geonode-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geonode-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/geonode-devel</a><br>
</blockquote></div>
<br>______________________________<wbr>_________________<br>
geonode-devel mailing list<br>
<a href="mailto:geonode-devel@lists.osgeo.org">geonode-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geonode-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/geonode-devel</a><br>
<br></blockquote></div></div>