<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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle21
{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="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Thanks Karl-Magnus – for some reason I thought they already had privileges but they didn’t, thanks again!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#BFBFBF;mso-fareast-language:EN-GB">Chris</span></b><span lang="EN-US" style="color:black;mso-fareast-language:EN-GB"><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 lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB"> Karl-Magnus
Jönsson [mailto:Karl-Magnus.Jonsson@kristianstad.se] <br>
<b>Sent:</b> 21 March 2016 06:27<br>
<b>To:</b> Chris Buckmaster; qgis-user@lists.osgeo.org<br>
<b>Subject:</b> SV: 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-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 lang="SV" 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 lang="SV" style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">
│GIS-utvecklare</span><span lang="SV" style="font-size:10.0pt;color:#1F497D;mso-fareast-language:SV"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV" 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 lang="SV" 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 lang="SV" 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 lang="SV" 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 lang="SV" style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1F497D;mso-fareast-language:SV">Tel 044-13 54 16 │ Mobil: 0733-13 54 16 │karl-magnus.jonsson@kristianstad.se<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV" 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 lang="SV" 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 lang="SV" 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 lang="SV" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:SV">Från:</span></b><span lang="SV" 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"><span lang="SV"><o:p> </o:p></span></p>
<p class="MsoNormal">Hi<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks, Chris<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>