[postgis-users] Connecting AutoCAD to PostGIS / setting up a read only user

[Mike Toews]

On 18 January 2013 05:43, Mark Volz <MarkVolz at co.lyon.mn.us> wrote:
> I am having a little bit of trouble connecting a AutoCAD Civil 3-D 2013 Client to PostGRES / PostGIS.  Here is what I have so far:    Originally I set up read only user account on PostGRES 9.1 / PostGIS 2.0 -64bit.  I verified the account works by connecting to PostGIS through qgis, and through ArcMap.  CAD unfortunately would not connect.  I could see the PostGIS tables however I would get an error if I tried to load the data.  At first I thought that the issue was that CAD could not work with PostGRES 9.1 / PostGIS 2.0.  However it turns out I can connect to PostGIS if I use the administrator account, instead of the user account that I created.

Hi Mark,

First, make sure the readonly account has SELECT privileges for the
spatial_ref_sys table and the geometry_columns view. Check the
PostgreSQL log on the server to see if there are any funny/odd queries
that return an error.

If this doesn't work, I recall a similar problem several years ago:
https://trac.osgeo.org/fdo/ticket/647

That bug appears to be fixed, but perhaps not. Try the workarounds
that I listed on the ticket. Otherwise ask someone on the FDO lists or
AutoCAD support.

-Mike