[Qgis-user] DB Manager geometry problems

[Chris Buckmaster]

Hi

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).

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?

Thanks, Chris

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160318/1ed71369/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgis_selectonlyuser.png
Type: image/png
Size: 18571 bytes
Desc: postgis_selectonlyuser.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160318/1ed71369/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgis_superuser.png
Type: image/png
Size: 18198 bytes
Desc: postgis_superuser.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160318/1ed71369/attachment-0001.png>