<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Franklin Gothic Book";
panose-1:2 11 5 3 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-postmall17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.E-postmall18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="SV" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Hi Chris<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Appears that the user can’t access the view geometry_columns in the public schema. The information is accessed from there. Grant select privileges.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">Karl-Magnus Jönsson</span></b><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">
</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">│GIS-utvecklare</span><span style="font-size:10.0pt;color:#1F497D;mso-fareast-language:SV"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">Kristianstads kommun<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">291 80 Kristianstad<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">Besöksadress: Västra Storgatan 12<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">Tel 044-13 54 16
</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">│</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV"> Mobil:
0733-13 54 16 </span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">│karl-magnus.jonsson@kristianstad.se</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#1F497D;mso-fareast-language:SV"><a href="http://www.kristianstad.se/"><span style="font-family:"Franklin Gothic Book","sans-serif"">www.kristianstad.se</span></a></span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:SV">Från:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:SV"> Qgis-user [mailto:qgis-user-bounces@lists.osgeo.org]
<b>För </b>Chris Buckmaster<br>
<b>Skickat:</b> den 18 mars 2016 16:34<br>
<b>Till:</b> qgis-user@lists.osgeo.org<br>
<b>Ämne:</b> [Qgis-user] DB Manager geometry problems<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-GB">Hi<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I have several datasets loaded into PostGIS 2.0 with the owner as ‘superuser’ that has full permissions. I have then assigned select permissions to some other users, but I am not sure if they completely have the access
they require as the DB Manager doesn’t show the spatial reference, and it says there is no entry in geometry_columns (attached are two screenshots which show what I get).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">For my superuser connection, the geometry symbol is next to the layer name and it has all of the geometry information in the window, but for one of my select only users it does not show – do I need to give my select only
users permission to access other tables in PostGIS? I have noticed that for larger datasets it takes quite a bit longer for the datasets to be loaded into PostGIS as well which leads me to believe that perhaps they are not accessing the spatial indexes or
something?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">Thanks, Chris<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
</div>
</body>
</html>