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

[Mark Volz]

Hello,

Does anyone know if CAD can use a read only account to connect to PostGIS, or do I need an account that had read and write permissions?  Also, if anyone has had success at allowing CAD users read only access to PostGIS I would appreciate tips on how to set up the users permissions in PostGIS.

Background:

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.

Thank You


Mark Volz
GIS Specialist